Solved

Sum a Total with ReportItems in SSRS

Posted on 2009-05-11
2
8,834 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 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