Lesson 1 Filter Options Screen Exit

As mentioned in the Introduction, this screen, the Filter Options screen, is VERY important in customizing your query. It restricts the data returned in the results of your query. Remember that the query is limited to returning no more than 1000 rows, so it is important to set filters appropriately. If the limit is exceeded, you will see the first 1000 rows of data along with a warning message that is displayed in red. Warning: The record limit has been exceeded and not all lines are displayed.

This report requires your adding three filters which all use the equal to operator. Other types of operators will be used in later reports. The filters must be added in the same order as the instructions in this tutorial; however, the order is not important when creating reports on the "live" data. If you need to delete a filter, highlight it and click Remove Filter. For Tutorial purposes only you must enter the filters in the exact order specified. Therefore, if you must remove a filter to make modifications you must remove all filters below it, and from that point re-enter each filter.

Adding filters requires four steps. The required four steps are documented in the left section of the screen.

*Hint - It may be helpful to print this screen to assist in entering filters.

  1. Select Agency Nbr (SAAS) in the Select Column box to highlight it.
  2. Select the operator equal to from the Operator drop-down list.
  3. Enter 130 in the Enter Value box.
  4. Click >>Add Filter to add the filter to the Filter Criteria box. (You might have to scroll to see this.)

Now, add the filter for restricting the fund number to 3125.

  1. Select Fund Nbr in the Select Column box to highlight it.
  2. Select the operator equal to from the Operator drop-down list.
  3. Enter 3125 in the Enter Value box.
  4. Click >>Add Filter to add the filter to the Filter Criteria box.

Finally, add the filter for restricting the budget year to 1999.

  1. Select Budget Year in the Select Column box to highlight it.
  2. Select the operator equal to from the Operator drop-down list.
  3. Enter 1999 in the Enter Value box
  4. Click >>Add Filter to add the filter to the Filter Criteria box
  5. Click Next to continue.

Filter Options
 
To add a filter:
1. Select the column to filter from the Filterable Columns listing.
2. Select one of the Operators from the Operator drop-down list.
3. Enter the value to filter for in the Value box.
4. Click the Add filter component to add the filter.
Repeat these steps to add additional filters.		1. Select Column
2. Select Operator


3. Enter Value
4. Add FilterFilter Criteria