reporting services - Dynamic Grand-total with lists and multi-value parameters -


Actually I've created a list that is subtotals according to the group

I then created a multi-value The parameter is created which allows the user to choose which group is shown in the report.

How can I get a grand total to reflect the parameter from the outside of the list?

To reflect your cool total parameter, you can place it in a one-line table ( No top / footer) Group by the same expression as your list, then filter the table with your parameters:

  = Field! YourField.Value = Parameter. Your value (0)  

Finally, in your huge total area, in the table, expression to get the correct number of = CountRows () Use the.

Hope it helps! --Read


Comments