﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Reporting Services / Reporting Services  / How to sum report items values in the body of the report? / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sun, 19 May 2013 00:21:19 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: How to sum report items values in the body of the report?</title><link>http://www.sqlservercentral.com/Forums/Topic1287159-150-1.aspx</link><description>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</description><pubDate>Mon, 26 Nov 2012 08:57:59 GMT</pubDate><dc:creator>neerajstar</dc:creator></item><item><title>RE: How to sum report items values in the body of the report?</title><link>http://www.sqlservercentral.com/Forums/Topic1287159-150-1.aspx</link><description>Usually I go back to the original query at that point and resolve the issue there.</description><pubDate>Mon, 12 Nov 2012 09:31:14 GMT</pubDate><dc:creator>Daniel Bowlin</dc:creator></item><item><title>RE: How to sum report items values in the body of the report?</title><link>http://www.sqlservercentral.com/Forums/Topic1287159-150-1.aspx</link><description>Having the same problem here!Did you found any solutions?Regards</description><pubDate>Mon, 12 Nov 2012 09:23:03 GMT</pubDate><dc:creator>davdam8</dc:creator></item><item><title>How to sum report items values in the body of the report?</title><link>http://www.sqlservercentral.com/Forums/Topic1287159-150-1.aspx</link><description>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</description><pubDate>Fri, 20 Apr 2012 08:09:15 GMT</pubDate><dc:creator>russellxup</dc:creator></item></channel></rss>