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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » How to sum report items values in the body of...

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

Rate Topic

Display Mode

Topic Options

Author

Message

russellxup

Posted Friday, April 20, 2012 8:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 11, 2012 2:01 AM
Points: 3, Visits: 43

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

Post #1287159

davdam8

Posted Monday, November 12, 2012 9:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 3:26 AM
Points: 156, Visits: 567

Having the same problem here!
Did you found any solutions?

Regards

Post #1383735

Daniel Bowlin

Posted Monday, November 12, 2012 9:31 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:10 PM
Points: 2,673, Visits: 2,418

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

Post #1383740

neerajstar

Posted Monday, November 26, 2012 8:57 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 20, 2013 9:13 AM
Points: 80, Visits: 83

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

Post #1388669

« Prev Topic | Next Topic »

Permissions