Solved

Sum subtotal on each page - rdlc report

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Fusion 11g - analysis vs report using DataModel 8 192
Webi 4.1 business objects  timeout 4 76
If Then Else Query in Cognos 10.0 4 105
web based reporting not a saas 9 62
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…
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

860 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