count rows in a report | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

count rows in a report

i have a report with 1 group and items under the group. i want to add a new field called Sl. no. at the group level which keeps the count on groups…by that i mean say if there are 10 groups i want the number from 1 to 10 appear against each group as
1 Grp1
2 Grp2
3 Grp3
10 Grp10
How can i achieve the above. I tried the rownumber but it returns the number of rows the group has. The levels i have is "table1" the main scope and "table1_Group1" the group scope which in the table1 scope. Any help will be appreciated.

See any help. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.