Solved

Sum subtotal on each page - rdlc report

Posted on 2009-05-05
2
3,002 Views
Last Modified: 2012-05-06
I need to get sum subtotal on each page of report, like below.
Can anybody help me?

page -1-

sum11           0.00
----------------------
a11            100.00
.          
.      
.
a1n            200.00
----------------------
sum12       300.00 (sum11+a11+..+a1n)


page -2-

sum21       300.00 (sum12)
----------------------
a21            400.00
.
.
.
a2n            500.00
----------------------
sum22    1,200.00 (sum21+a21+..+a2n)


page -3-
.
.
.

Thanks.

0
Comment
Question by:trigeminus
2 Comments
 
LVL 21

Accepted Solution

by:
JestersGrind earned 500 total points
ID: 24304212
In your group footer, put in the following expression:

=RunningValue(Fields!YourFieldName.Value, Sum, Nothing)

Greg


0
 

Author Comment

by:trigeminus
ID: 24304539
Thanks for your suggestion Greg, but how to group the data by page (1 group - 1 page)?
Without grouping total sum repeats on each page.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

813 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

16 Experts available now in Live!

Get 1:1 Help Now