Post reply

Show SUM total on every page

  • November 12, 2010 at 12:11 pm

    #228971

    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 😎

  • November 15, 2010 at 7:02 am

    #1250703

    Add a textbox to the footer, then sum the field you want using the name of the textbox (not the field name). Lets say your textbox name is txtMyTextBox, the expression in the textbox in the footer would be =SUM(ReportItems!txtMyTextBox.value)

  • November 15, 2010 at 7:06 am

    #1250710

    Thanks... i was thinking of that but wanted to know if there was some other way...

  • January 13, 2011 at 1:16 am

    #1272841

    Thanks! It's the solution that I'm looking for.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply