You need to create a calculated data item that is the total of all your numeric columns and create a filter that would compare against zero.
Steps:
1. Create a calculated data item that totals all of your numeric columns that could have a zero value. This data item will not be be used in the report but will act as filter in the underlying query.
2. Create a detailed filter in the query that compares the data item created in item 1 and compare it against a zero value. To display a row we are testing for a row is not equal to zero [calculatedsum] <> 0.
3. Ensure that the application of the filter is done after aggregation.
Run the report. You should see that any rows that have all zeros in the value columns will not be displayed.
This wouldn't work if Item 1 =2 and Item 2=2... Wouldn't it be better if you used Item 1 <> 0 OR Item 2 <> 0
ReplyDelete