Suppressing zero values

The fact that the Van Tires element and its children contain only zero values enables us to use a different method to remove those products from the report.

  1. In Design mode, click the Product hyperblock to enable the List Designer.
  2. In the Filter pane, select each regular expression filter and click Remove.
  3. Click New filter.
  4. Select Value from the Filter By list.
  5. Select Does not equal from the Condition list.
  6. Double-click in the Value field and specify 0.
  7. In the Data Area, click the Fill button.
    The Data Area is populated with the hierarchies that are referenced in the report.
    Note: Whenever you filter, or sort, by a value, you must specify the data area. That is, the area of the database to which to apply the filter. In this exercise we do not change the values of the data area.
  8. The filter is defined as Value does not equal 0.
    This means Display all values that are not zero.
  9. Click Apply changes to the list and view the report in View mode. Suppressing the zero values, has achieved the same result as using structure selection and using regular expressions. In this report, with this data, using zero suppression is the most appropriate method.