Solved

Sum subtotal on each page - rdlc report

Posted on 2009-05-05
2
2,957 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
Comment Utility
In your group footer, put in the following expression:

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

Greg


0
 

Author Comment

by:trigeminus
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
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 …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 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