Post reply

Add average on each page in ssrs 2008

  • March 28, 2011 at 12:26 pm

    #237543

    Hi,

    I have a report which has a column with numeric values. I want to show average of values of that column on the same page and same needs to be done on each page. Is there any idea how can I achieve this as number of rows and when pagebreak will be there is not sure everytime.

    Thanks!

    :rolleyes:

  • March 28, 2011 at 12:55 pm

    #1304527

    Put a text box in the footer. Add an expression for the value of the textbox, something like

    =AVG(ReportItems!TextboxYouWantToAverage.Value). You are using a ReportItems reference, not a field reference. ReportItems refer to the actual textboxes on the report, each one has a unique name that can be found under TextBox properties for that cell.

  • March 28, 2011 at 1:16 pm

    #1304542

    Thanks Daniel..! It worked for me..! 🙂

    :rolleyes:

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

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