Reporting Services - Summing Group Header Values
Posted on 2009-03-31
I have a report that is laid out like this:
Group Header Client
Group Header Account
First, I have deleted the detail row as I have no interest in viewing individual transactions. I have decided to hide Account groups that do not have a total transation amount of 20,000. I also show that sum amount in the Account Group Header. Now, I'm trying to sum all Account groups within the Client group. My problem is that I don't want all transaction to be included within the Client sum. I only want the transactions that were part of the Account group sums. I only want to sum the Account group sums. I tried referencing the Account sum cell using ReportItems but it appears that I can only do that in a page header/footer. Is there any way to accomplish what I'm trying to do?