Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to sum report items values in the body of the report? Expand / Collapse
Author
Message
Posted Friday, April 20, 2012 8:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, November 12, 2012 9:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

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

Regards
Post #1383735
Posted Monday, November 12, 2012 9:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:36 PM
Points: 2,818, Visits: 2,565
Usually I go back to the original query at that point and resolve the issue there.
Post #1383740
Posted Monday, November 26, 2012 8:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 7:45 PM
Points: 112, Visits: 101
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 »

Add to briefcase

Permissions Expand / Collapse