March 23, 2012 at 6:08 am
Hi All,
I'm trying to create a group within a table in Reporting Servoces, but I keep getting the following error message:
Error 1 [rsInvalidAggregateScope] The SortExpression expression for the grouping ‘Group1’ 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..
Would anyone let me know how I would be able to resolve the problem please?
Thank you!
March 23, 2012 at 7:15 am
You need to look at the group properties. The sort expression probably needs a scope added to it. For example perhaps your current sort expression is =Fields!FieldName.Value
You probably need something like = (Fields!FieldName.Value,"Group1") assuming "Group1" is the name of the scope for your group.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply