Group Totals Help

[dzavad]

Hi,
I have report (ssrs 2005)where I have to calculate sub totals per group.
This report is simple , all I have is two groups in the table.
Group 1 Facility
Group 2 Department

Now, Group 2 have one TextBox where I calculate "Total Reviewed" Code: count(Fields!Review_Status.Value). No problem here.
Also, Group 2 filters Top 20 records based on Code:=count(Fields!Review_Status.Value) on Filter tab.
Thats where I have an isue with Totaling Top 20 records on Group 1 Facility code:=count(Fields!Review_Status.Value), and many , many other combination dont work along with RunnibgValue.
How can I do summary between groups in SSRS 2005.
I am a crystal developer and this stump me in SSRS.

 

[xlbo]

Maybe have a look at the InScope function....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question