Achieving zero suppression
We have already seen one way of suppressing zero rows in the Filtering rows or columns recipe. This recipe will show other possible ways to achieve zero suppression.
Getting ready
We will use the same report used in the Filtering rows or columns recipe, for this recipe.
How to do it...
In this recipe we will use the Crosstab properties to suppress zeros from the report as follows:
Open the report and remove the Expression Definition created in the original recipe and add Retailer name.
Now, select anything on the crosstab, and using the Ancestor button from the Properties tab, select the crosstab.
Open its Suppression property:
Select the Rows only option for Suppression and keep the appropriate checkboxes checked:
Run the report to test it.
How it works...
When you run the report, you will see that only those Retailers which have some data appear on the rows. This effect is the same as the filtering we had achieved by using the calculated member set.
I would say this is...
