Post reply

Report Totals

  • September 6, 2005 at 10:30 am

    #152533

    SQL Reporting Service

    I might be missing something? In Access, I could create a report footer. I only see Page Footer options and even then it wont let me use Fields in the Page Footer? Any help?

    - Scott

  • September 6, 2005 at 11:27 pm

    #587995

    Drag and drop a table from your toolbox to your report.  Drop a numeric field into a column on the footer row.

    Voila! A total.

    If you already have a table with a detail section, click anywhere on the table, then right click on one of the icons on the left of the rows. Select Table footer. Now drop a field in the footer for a total.

    To manually add a total in a footer, use =Sum(Fields!YourField.Value).

    I hope this is of some help to you.

  • September 7, 2005 at 6:16 am

    #588047

    Thanks. That was too easy.

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

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