Example: Remove records that have a specific value:
  1. Go to Report > Select Expert
  2. Select the field you are concerned with and click OK
  3. Select "is not equal to" from the drop down list on the left
  4. Select the value you would like to remove from the report from the drop down list on the right
  5. Click OK and refresh the report


Example: Include records that have one of several values:

  1. Go to Report > Select Expert
  2. Select the field you are concerned with and click OK
  3. Select "is one of" from the drop down list on the left
  4. Select the values you would like to include in the report from the drop down list on the right
  5. Click OK and refresh the report

Example: Include records that have a date within a specific date range:
  1. Go to Report > Select Expert
  2. Select the date field you are concerned with and click OK
  3. Select "is between" from the drop down list on the left
  4. Enter the start date of the date range in the first box on the right
  5. Enter the end date of the date range in the second box on the right
  6. Click OK and refresh the report

Note: If you would like to use a formula that contains a summary field or a variable, you will not be able to use this formula field in the Select Expert. In this case, you can suppress the sections in your report to remove the records that shouldn't show using the Section Expert.

Example: Remove records with a formula value less than 10
  1. Go to Report > Section Expert
  2. Highlight the first section that will show data in the preview from the list of sections on the left
  3. Click X+2 across from Suppress (No Drill-Down)
  4. Enter the formula: @Formula_Field < 10
  5. Click Save and Close
  6. Repeat steps 2-5 for all sections that will show data in the preview
  7. Click OK