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 as1 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.
Seehttp://blogs.msdn.com/bimusings/archive/2005/07/26/443511.aspx any help. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
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.
]]>