Not include hidden rows in group summary? SSRS 2005

[dianemarie]

Hello, I have a report with two groups, and am summarizing a quantity field from the detail row on the group #2 footer. Group 2 footer has a conditional visibility property. Then the group 2 summary field is summarized on Group 1, but it is summarizing the hidden quantities on Group 2. I want it to summarize only what is showing on the report. Is this possible or do I need to rethink the whole thing? Thank you for any help.

 

[NathanGriffiths]

Hi Diane,

How are you hiding the detail rows in Group 2? I think you would probably need to replicate the logic for this in the summary field in Group 1.

e.g. if your Group 2 detail row Hidden expression was something like

=Iif(Fields!Myfield.Value > 10, True, False)

Then your summary field would need to be something like

=Sum(Iif((Fields!Myfield.Value, "Group1") > 10, 0, (Fields!Myfield.Value, "Group1"))

i.e. if the Group 2 row is hidden then sum zero else sum the value of the field in Group 2.

Regards,

Nathan

 

[dianemarie]

Thank you Nathan. I can see how this would work if I was only conditionally suppressing records, but my report is also filtering records. I'm still working on this, found some code for running totals that I'm messing with.