How to add total in SSRS 2005

2.1k views Asked by At

How to add total in ssrs report using ssrs 2005 manually without using a wizard? I can do it in ssrs 2008 by simply add total and

Additional question: it seems it is hard to group records here in ssrs 2005 i cannot see row groups and column groups.

1

There are 1 answers

0
Ian Preston On

For a table total, you will need to enable the header and/or footer; you can do this by right clicking on the left side of the table:

enter image description here

For a group total, you will need to right click the left of the group row and enable headers/footers in the properties:

enter image description here

enter image description here

Addressing your second question, you cannot compare the 2005 report items/designer to 2008 and above - there was a major redesign of this in 2008. The List, Table and Matrix controls were merged in 2008 into one underlying Tablix object, and the row/column grouping and the way this was managed was changed accordingly; the Row Groups/Column Groups section in BIDS was introduced in 2008. See The New Report Designer And Tablix for some more detail here.