SQLTeam.com | Weblogs | Forums

Use aggregate before page header


#1

Hi

I have a report builder that need to calculate all "active" and place it the total before the page header. upon running the report i encountered this error. any help is very much appreciated. thank you.

The Value expression for the textrun ‘Textbox20.Paragraphs[0].TextRuns[0]’ 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.

below is the code in my expression.

=IIF(SUM(Fields!VENDACCOUNT.Value LIKE "active*",1,0), "DataSet2"))


#2

Looks like you have placed the TextBox20 outside the group,try to place it inside the group.