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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics