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

Please look over the screen shots and let know what I am doing wrong.
Sam
ReportItems.JPG
screenshot1.JPG
screenshot2.jpg
SamRunyonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
shorakConnect With a Mentor Commented:
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.

See how it goes.

Rob
0
 
SamRunyonAuthor Commented:
Shorak, you help me big time... the reportitems sums only work in the page footer.. not the table footer.
There are a dozen post on this subject. No one pointed that out.

That fix "this" Problem.

thanks for the help.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.