SQL Server Performance

Help with totals!!!

Discussion in 'SQL Server Reporting Services' started by sqlchat, Sep 20, 2004.

  1. sqlchat New Member

    I have a simple select query displayed in Table control. What I want to do is to display a total at the end of each page ( In the table footer or page footer ). Its actually a sum of a particular column. How do I do this.
  2. Akthar New Member

    Hi,

    To add totals just add the field in your page footer, the report designer will automatically assign the necessary formula

    Try it and let my know if you require more infos

    Akthar
  3. fountainhead New Member

    Hello Akthar,

    I have tried what you suggested but I get this reporting error. "The Value expression for the textboxname refers to a field. Fields cannot be used in page headers or footers.
    Any further suggestion would greatly be appreciated.

    Thank You!
  4. bijesh New Member

    Hello,
    From the field list, just drag drop the relative field to table footer or report footer section. On doing so, you might see the formula as "=Sum(Fields!Col1.Value)". This will give you the total of the column that you have displayed in the detail section of the table.

    Thanks,

    Bijesh
  5. fountainhead New Member

    Hi Bijesh,

    Thanks for your reply,My exact requirement is to get page level totals on each page of the report. If I drag drop the relative field to table footer, the result is total of that column for the complete report. If I drag drop the relative field to report footer that's when I get the above posted error. If you have any suggestion please let me know how to display column total for each page? Thanks for your help in advance!

    Thank you!
  6. bijesh New Member

Share This Page