SSRS 2005 - Group Counting

How do you show the current GROUP counts through SSRS 2005?

I have a report in which there are n groups where the original data should remain anonymous, and I want this number in the group header ...

Therefore, instead of the name in the group header, for example ...
Employee - John Smith
Employee - Mary Swain
...
Employee - Ahmad Sal

I want...
Employee No. 1
Employee number 2
...
Employee #n


Thanks!!!

+6
reporting-services reportingservices-2005
source share
3 answers

Use

RowNumber("table1_Group1") 
+3
source share

=RunningValue(Fields!Employee.Value, CountDistinct, Nothing)

Voila!

+19
source share

OK, I have a workaround that is valid only because the number of rows is constant for each group.

 =(RowNumber("table2"))/(RowNumber("table2_Group1")) 

This will work as part of this report, but it still seems like there should be an easier way ...

0
source share

All Articles