April 7, 2011 at 3:58 am
I have an SSRS report with a table linked to a procedure which contains invoice header and detail information. If there is more that one detail line the header information in repeated. I have setup groups to keep the header information from repeating on the report and I now need to add up the invoice totals off the header information without duplicating any of the invoice totals. I found reference to the following aggregate:
=Sum(Fields!Balance.Value,"Balance")
Balance is the name of the group containing the invoice total and what I've seen says this syntax is correct but I am getting an error:
[rsInvalidAggregateScope] The Value expression for the text box Balance has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.
Is there a good way to determine how to fix this aggregate function or is there a better way to determine the sum which excludes duplicates?
Thanks
Chuck
April 7, 2011 at 9:18 am
It is most likely the "Balance" portion of the formula. This should be the name of the data region on the report/Tablix. The name typically defaults to something like Group1 unless you change it.
Highlight the Tablix and look at the bottom of the design screen. It will show you the names of each group/data region that you have defined or created.
April 7, 2011 at 10:01 am
Balance is the name of a group There are serveral groups. Would that be a problem?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply