Create a Level Filter

Level filters are similar to the filters that are applied to the main report.

While report filters are applied to the report as a whole, restricting the data that's returned at any level in the report, level filters are applied to individual output levels and only restrict the data returned at the level where they're created. If the report has multiple output levels, the other levels aren't subject to the level filters applied to other levels in the report.

  1. Open the report you want to edit.
  2. Select the level you want to add the filter to from the Level drop-down list at the top of the design surface.
  3. Click the Level tab.
  4. Click Add Level Filter.
    The Add Filter window opens.
  5. Enter field information described in Create a Fixed or Runtime Selectable Filter.
  6. Click OK.
  7. Click Save.