Create Sum of calculated rows in Microsoft Reporting Services

Posted by kd7iwp on Stack Overflow See other posts from Stack Overflow or by kd7iwp
Published on 2009-03-11T22:06:34Z Indexed on 2010/04/15 10:33 UTC
Read the original article Hit count: 331

Filed under:
|

This seems like it should be simple but I can't find anything yet. In Reporting Services I have a table with up to 6 rows that all have calculated values and dynamic visibility. I would like to sum these rows. Basically I have a number of invoice items and want to make a total. I can't change anything on the DB side since my stored procedures are used elsewhere in the system. Each row pulls data from a different dataset as well, so I can't do a sum of the dataset. Can I sum all the rows with a table footer? Similarly to totaling a number of rows in Excel? It seems very redundant to put my visibility expression from each row into my footer row to calculate the sum.

© Stack Overflow or respective owner

Related posts about reporting-services

Related posts about sum