views:

232

answers:

2

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

A: 

Use

RowNumber("table1_Group1")
IMHO
This returns the number of rows in the group, not the actual group number...
Dining Philanderer
If you put it in detail row - it will return current row
IMHO
A: 

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

Dining Philanderer