Exclude hidden rows from totals
Posted on 2011-04-25
Good afternoon. I have a report in SQL Reporting Services 2005 that contains numbers for a particular situation, broken into months. So, there are columns for each month. In some cases, the numbers from one month might offset the numbers from a previous month, leaving a YTD total of zero. When this occurs, I suppress the row entirely using a Visibility, Hidden expression. This is working fine.
However, the grand totals for each month (column) are still including these hidden rows. I have not been able to figure out how to make sure this doesn't happen. I did find through Google some advice to filter the table so it does not include the hidden rows, but the suggestion did not include any sample code.
Can anyone provide a filter expression that will exclude hidden rows? Or provide some other method to ensure the totals for each month do not include hidden rows?