How to sum report items values in the body of the report?

• russellxup

  SSC Veteran

  Points: 265

  More actions

  April 20, 2012 at 8:09 am

  #260289

  Hi guys!

  I'm the beginner in SSRS and I have a problem, which I'm not able to manage with.

  I know that expression Sum(ReportItems!Textbox.Value) can be only used in page header/footer.

  And in my report I really need this functionality in the body of the report ( sum(Fields! .value) expression doesn't sum correctly, because of report specificity) .

  Do you know any workaround to return the same values as sum(ReportItems!Textbox.Value) expression, which could be used in the body of the report?

  I would be really grateful for any help.

  Kind regards,

  Russell

• davdam8

  Hall of Fame

  Points: 3620

  More actions

  November 12, 2012 at 9:23 am

  #1558207

  Having the same problem here!

  Did you found any solutions?

  Regards

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  November 12, 2012 at 9:31 am

  #1558211

  Usually I go back to the original query at that point and resolve the issue there.

• neerajstar

  Old Hand

  Points: 330

  More actions

  November 26, 2012 at 8:58 am

  #1562269

  Hi,

  If I understand well, You are looking for running total. for that write an expression on the report field to compute.

  =runningvalue(Field!SomeFieldName,Sum,"Datasetname")

  Thanks,

  Neeraj K