Solved

Sum subtotal on each page - rdlc report

Posted on 2009-05-05
2
2,984 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

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

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 …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

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

15 Experts available now in Live!

Get 1:1 Help Now