Running Total at Page Footer.
Hi Team,
i am using Sum(ReportItems!Internet_Sales_Amount.Value) to get the Page Total of Internet_Sales_Amount.Value at the Page Footer.
What i now need is the Running Value :
Page2=Page2 Total +Page1 Total
page 3 =page 3 Total + Page 2 Total +Page 1 Total
Can somebody let me know is there any Vb function or Expression to achieve this ?
Rakesh M J
Dont forget to mark it as Answered if found useful
MCTS,MCITP,MCSS
http://myspeakonbi.blogspot.com/
July 3rd, 2011 2:23am
You can try to force a page break after every 20 or 25 records, and then probably you can control this. To force a page break after a certain number of records, see
http://msdn.microsoft.com/en-us/library/ms157328.aspx#AppearanceofReportData, this says:
Page Breaks
In some reports, you may want to place a page break at the end of a specified number of rows instead of, or in addition to, on groups or report items. To do this, create a group that contains the groups or detail records you want, add a page break to the
group, and then add a group expression to group by a specified number of rows.
The following expression, when placed in the group expression, assigns a number to each set of 25 rows. When a page break is defined for the group, this expression results in a page break every 25 rows.
Copy Code
=Ceiling(RowNumber(Nothing)/25)
To allow the user to set a value for the number of rows per page, create a parameter named
RowsPerPage and base the group expression on the parameter, as shown in the following expression:
Copy Code
=Ceiling(RowNumber(Nothing)/Parameters!RowsPerPage.Value)
So, probably you can now use SQL Server to caculate the sum for first 20 records in page1, first 40 records in page2, and so on..
I couldnt think of any option..
I also found a similar post here:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0f7825a9-8082-4081-9517-889edb3f9d8b/ [Carry over page totals]
Hope this helps..
Chaitanya( Twitter |
Blogs )
Any documentation bug? Tell us about it at
Connect. Please feel free to add any community comments in any of the MSDN/technet articles.
This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2011 7:39am