6
votes

How do you you display the running GROUP count via SSRS 2005?

I have a report that has n groups where the source data must remain anonymous and I want that number in the header of the group...

So instead of the name in the group header like such...
Employee - John Smith
Employee - Mary Swain
...
Employee - Ahmad Sal

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


Thanks!!!

3

3 Answers

22
votes

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

Voila!

3
votes

Use

RowNumber("table1_Group1")
0
votes

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

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

This will work for the scope of this report, but it still seems like there should be an easier way...