Print Page - Repeating rownumbers for duplicate rows?

Title: Repeating rownumbers for duplicate rows?
Post by: naveen10046 on 11 Jul 2012 05:27:46 AM

Hi Guys,

I have a requirement to display rownumber in the below format :

Number Name
1    Alexandra Trower
1    Alexandra Trower
1    Alfonso Emanuele
1    Alfonso Emanuele
2    Ampornpim Vajrabhaya
2    Ampornpim Vajrabhaya
3    Amy DiGeso
3    Amy DiGeso
3    Amy DiGeso
4    Andreas Serpanos
4    Andreas Serpanos

Thanks in advance
Naveen

Title: Re: Repeating rownumbers for duplicate rows?
Post by: naveen10046 on 11 Jul 2012 05:59:58 AM

Hey Guys,

I got the solution, here it is:

Need to create a dataitem with the expression :

running-count(distinct[NAME])

Regards,
Naveen

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: naveen10046 on 11 Jul 2012 05:27:46 AM