Return Closing Balance

• ttdeveloper

  SSCrazy

  Points: 2370

  More actions

  January 28, 2015 at 1:59 pm

  #294280

  Good Day All

  I have an SSRS report with a tablix where I need to return the closing balance based on the max value returned. I have attached a file with details of what i am looking for. Essentially my tablix has a SUM function as a total and for this one row, I need to SUM and keep the Scope in line with the child group immediately below this one.

  Updating the Sum with scope as the child group fails saying the scope is invalid

  "The Value expression for the text box ‘ELIS_LY4’ 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"

  Please see attached and let me know if I need to clarify anything..Thank you for your help

• ttdeveloper

  SSCrazy

  Points: 2370

  More actions

  January 29, 2015 at 7:39 am

  #1774006

  I was able to solve my problem. SSRS does not allow aggregations on child scopes as those scopes are essentially not the current or containing scope.

  I now know that the only way to get this done is to use the child scope in a nested aggregate

  In my case

  =LAST(SUM(Fields!ELIS_LY.Value, "Monthnm2"))

  http://stackoverflow.com/questions/22770266/ssrs-2008-r2-countrowsgroupname-doesnt-work