Suppressing zero values

In this example, the knowledge that 2006 and subsequent years contain only zero values enables us to use a different type of filter to remove those years from the report.

  1. In Design Mode, click the Period hyperblock to enable the List Designer.
  2. In the Filter pane, select each 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.
    Note: Whenever you filter (or sort) by a value, you have to specify the Data Area. That is, the area of the database to which to apply the filter.
  7. Click the Fill button.
    The Data Area is populated with the elements selected in the report.
  8. The filter is defined as Value filter: 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. By suppressing the zero values, we have achieved the same result as by using the regular expression.