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.TextRuns’ 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"))