Solved

Sum a Total with ReportItems in SSRS

Posted on 2009-05-11
2
8,096 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

896 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now