Sum a Total with ReportItems in SSRS

My report is pulling daily info. doing some math with the textbox name fields.
That part works.

Now I need to do a Total at the bottom of the page for AVG and SUM. I get this error.
when I try this expression.

=Sum(REPORTITEMS!B.Value+ReportItems!C.value)

the error is:
[rsAggregateReportItemInBody] The Value expression for the textbox 'textbox18' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers.
[rsReportItemReference] The Value expression for the textbox textbox18 refers to the report item B. Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope.
[rsReportItemReference] The Value expression for the textbox textbox18 refers to the report item C. Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope.
Build complete -- 3 errors, 0 warnings

This might solve some of your problems.. in screenshot2 replace the formula in column D with:

=Fields!ClassicVolume.Value+Fields!TotalEFMVolume_1.Value

Do the same for table in the reportitems screenshot replacing the reportitems reference with the actual fieldname.

The reason why your getting these errors is because you are referencing a report item rather than the actual dataset field within the main body of the report and reporting services dosnt like that. The only time you can refer to a report item is when your referring to a text box in the header/footer from the main body or visa versa.

Hi All,
I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …

Hi,
I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…

In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…