Solved

Sum a Total with ReportItems in SSRS

Posted on 2009-05-11
2
8,251 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:SamRunyon
2 Comments
 
LVL 11

Accepted Solution

by:
shorak earned 500 total points
ID: 24361954
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
 

Author Comment

by:SamRunyon
ID: 24363092
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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question