Post reply

The value expression for the text box 'blahblahblah' specifies a scope that is not valid for a nested aggregate

  • August 8, 2012 at 11:48 am

    #265568

    I've been pulling my hair out on this one for a while. I have a report with multiple groups in a heirarchy. I am trying to get the sum of a max within a group and have been trying formulas similar to:

    Sum(Max(Fields!Budget.Value, "GroupName"))... I get the error message above when attempting to use this in a formula I'm not understanding why this is so difficult.. Crystal Reports has always had this functionality. I've seen multiple posts and some responses say to use another dataset. This isn't an option as the dataset I'm using spans over 40 databases, and I can't have that overhead repeated for another query to get the values that already exist in my original query.

    I am using SSRS 2008R2

    What could be the problem?

  • August 8, 2012 at 1:57 pm

    #1523397

    If you use something like

    MAX(Budget) OVER(Groupname column) AS GroupMax

    as an additional column in your existing query ( not a new query, just a modification) you should be able to sum that column in SSRS the way you like.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply