How to SubTotal a filtered "Column Group"
Hello,
I've been working on an SSRS 2008 report and I'm having some trouble getting the total from a filtered column group. I'm using a dataset from an MDX query and need to grab all records because I calculate totals on the entire set. From there, I've grouped
the records by type and filtered the group to only view certain types.
After receiving all the records from the orginal dataset query, all the attempts at using Sum(fields!fieldname.Value) only calculates the total of all types.
Is there a way to calculate the sum (subtotal) of the filtered types in the column group and not include all of the unfiltered records returned from the original dataset query?
Thanks so much in advance,
Evan
October 6th, 2010 9:52pm
All RS aggregate functions support a scope parameter. The scope can be the name of a group defined in the report. Have you tried using the scope parameter in your aggregates?
Hope this helps,
-LukaszGot a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
October 12th, 2010 5:58pm