Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 SSRS Expression- Adding Totals per page

Author  Topic 

SSRS_Robert
Starting Member

1 Post

Posted - 2015-03-08 : 14:13:45
Hello Everyone,


I need an expression to add a total per page in SSRS in the footer of the report. Click on link to see screenshot.

So when users run SSRS, the first page must show a total for order qty , ship qty and subtotal for the first page only.

When users go to the second page, the it must show the total for order qty, ship qty and subtotal for the second page only as in the screenshot below.

The data region that is being used is a table region, and on the footer textboxes are being used to add totals for order qty, ship qty and subtotal.


Let me know if there is any expression that can do that and how I would add it to the footer. I thank you all in advance for helping !!

http://tinypic.com/view.php?pic=ie00fb&s=8
   

- Advertisement -