Show SUM total on every page
Hello, I'm a newbie with SSRS (2008). Im developing some reports but having a lot of difficulties. I need to show the SUM of my column on the bottom of the result from my dataset. So far i've been able to do this but, if i have more than 1 page of data, this SUM only shows up on the last page. Is there a way to show, on every page, the SUM of data on the Page and the TOTAL SUM from the dataSet? Thanks in advance, SuperJB JB
November 12th, 2010 2:28pm

This might help you http://www.merchantcircle.com/blogs/ACE.Microtechnology.Inc..770-889-2135/2010/2/Creating-Page-Totals-with-SSRS-can-be-a-bit-Challenging..../516007 Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 2:49pm

Hi SuperJB, By generally, we aggregate the total in the group footer of tablix footer, you might also achieve this by doing so. In order to display the total sum in every page, we need to set the tablix footer repeated. Please refer to the steps below: 1. Select the Tablix in the report. 2. In the Groups pane, click the small triangle arrow at the top-right corner and select "Advanced Mode" to show static members. 3. In the Row Group hierarchy, select the (Static) item which corresponding to the group footer or tablix header in the table. 4. Specify the RepeatOnNewPage property to True, the KeepWithGroup property to Before, and the FixedData property to False. After that, the total sum would repeated in every page. In order to show the sum of data on every page, if there are groups in the tablix and the page break depends on the group, we can simply add a group footer, then specify the sum aggregation in it. However, if the page break only depends on the page size, we need to aggregate the sum for the current page in the page footer, please refer to the steps below: 1. Add Page Footer in the report. 2. Add a Textbox in the Page Footer. 3. Specify the expression in the Textbox like =Sum(ReportItems!TextboxName.Value) Please correct the Textbox name in the expression to the textbox in which the data field needs to be aggregated. 4. We can also add another Textbox to the PageFooter to refer to the totol sum in the tablix footer by the expression like =ReportItems!TextboxName.Value Please also correct the Textbox name in the expression, and then hide the original tablix footer in the tablix. If something is unclear, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
November 16th, 2010 3:44am

Hi Tony, In my example, textbox X may contains blank values too. Then how will handle this- =Sum(ReportItems!X.Value) for blank value? I had tried =SUM( IIF(ReportItems!X.Value = "", 0, ReportItems!X.Value)) but I had got following error- The Value expression for the textbox Y refers to more than one report item. An expression in a page header or footer can refer to only one report item.
Free Windows Admin Tool Kit Click here and download it now
August 17th, 2012 7:01am

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

Other recent topics Other recent topics