Report Builder RC1 - Total on a Grouping
Hi Dev Team,
On a Tablix, when you create a grouping with a filter and ask for a Grouping Total, the system calculate the Grand Total rather than a total of the filter by default.
When I wanted to add the reference to the Group in the sum function I got an error.
The Value expression for the text box 'textbox12' has a scope parameter that is not valid for an aggregate function. The scope parameter much be set to a string constant .....
I check the name and it's setup as a mane of my group.
Upvotes: 0<=-=Sep 24 2008 5:38PM=-=>
Thank you for providing this feedback. The functionality you are asking about is not available in Reporting Services today. You would need to re-apply the same filter logic to your total directly or apply the filter to your dataset. It is not possible to reference the filter on the group in your total. We do have plans to add features that would support this scenario in the future but they have not yet been implemented.