Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS 2005 - Running Group Count

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!!!

like image 444
DiningPhilanderer Avatar asked May 12 '10 13:05

DiningPhilanderer


2 Answers

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

Voila!

like image 65
Riegardt Steyn Avatar answered Sep 24 '22 12:09

Riegardt Steyn


Use

RowNumber("table1_Group1")
like image 28
IMHO Avatar answered Sep 26 '22 12:09

IMHO