---
title: "Filtering a Report"
canonical: "https://kb.uconn.edu/space/DMRA/10883891311/Filtering%20a%20Report"
format: markdown
---
Once a report is created, filters enable you to customize the display of data in your report. This gives you the advantage of viewing only the data that you want to see and  
use.

> ℹ️ Refer to [Creating Basic Reports ](https://uconn.atlassian.net/wiki/spaces/DMRA/pages/10883891289)prior to going through the steps of this article.

## Filters 

1. Right-click on a field from the left **Data** navigation pane.
2. Click **Filter** from the menu that displays.
3. Notice a **Create a filtering condition** dialog box displays with the basic framework for a **WHERE** statement. The arithmetic operator is set to **Equal to** by default.
4. Modify this operator by double-clicking **Equal to. **
5. Then click the "Equal to" **drop-down arrow** to display the available options.
6. Click to select an option from the list, as desired.
7. To modify the type of filter in use, double-click the **<Value> **field.  
> Macro (inline-media-image)
8. Then click the "Value" **drop-down arrow** to display a list of additional options.
9. From the **Value** dialog box, click the **Type** drop-down arrow to modify this selection, as desired. Available options are listed and briefly defined below.
  1. **Constant. **Allows the entry of a literal value. This value can be a positive number, a negative number, or any character string.
  2. **Parameter. **Allows you to specify a parameter by entering a name and description in the provided text input areas, as well as selecting the type of parameter (Simple, Static, or Dynamic).
  3. **Field. **Allows the specification of a field name to compare against.   
> Macro (inline-media-image)

### Constant Filter Type 

1. The **Constant** selection from the **Type** drop-down allows you to either:
  1. Type the value(s) in the **Value** field.
  2. Highlight the line item** **in the left **Value** pane.
  3. Then click the** double chevron **to add it to the list of available options.
  4. Repeat these steps for each value that should be added. Alternatively,
  5. Retrieve all the available values from the database by clicking the **Get Values** drop-down.
  6. Select an option from the drop-down.
  7. Then click the respective **double chevron.  **
  8. Repeat these steps for each option that should be added from the **Get Values** dropdown.
2. Once the values appear on the right within the **Multiple Values** pane, select a value and click the **up/down arrows **to reorder, or click the **red X **to delete a value from the right.
3. Click **OK** to confirm and return to the **WHERE **statement view.

### Parameter Filter Type 

![Parameter Options ](media://69f3e8a0-9ed0-4697-833c-870befdeefcb)

1. Once Parameter is selected from the **Type** dropdown, available options include:
  1. **Simple.** This is used for prompts using Text Input. This is the default value.
  2. **Static.** This is used for prompts using Selection. This option allows you to select from a user-defined list of values at run time.
  3. **Dynamic.** This is used for prompts using Data Values. This option allows you to select from a list of all values at run time.
  4. You can also select **Optional** to indicate that the selected value (Simple, Static, Dynamic) is optional when running the report.

#### Simple Parameter Filter 

For our example, we will use EMPLID. 

1. Select the **Simple** radio button.
2. Enter text in the **Description** field exactly as you would like it to be seen by the person running the report.
3. Click **OK** to confirm and return to the **WHERE **statement view.

#### Static Parameter Filter 

For our example, we will use ACAD_PROG_PRIMARY. 

1. Select the **Static** radio button.
2. Enter text in the **Description **field exactly as you would like it to be seen by the person running the report.
3. Enter the appropriate text in the **Value** field, and then click the **double arrow **to add to the **Multiple Values **list on the right. This list displays the values the user will see in the drop-down for this parameter when running the report.
4. Click **OK **to confirm and return to the **WHERE **statement view.

#### Dynamic Parameter Filter 

For our example, we will use Term Codes.  

1. Select the **Dynamic **radio button.
2. Enter text in the **Description **field exactly as you would like it to be seen by the person running the report.
3. To allow the selection of multiple terms at the time of running the report, check off **Select multiple values at runtime. **
4. Select **Descending **as the sort prompt order option. Sorting in descending order is recommended for this example, as this allows the most recent term to appear at the top of the list.
5. In the Search Fields section, select the field that is being filtered; this should match the text that displays in the Name field above.
6. Click **OK **to confirm and return to the **WHERE **statement view.

> ℹ️ <span style="color: #333333">Vendor videos are available for additional relevant information (e.g., </span>[How to Use Filters](https://webfocusinfocenter.informationbuilders.com/wfappent/videos3/InfoAssist/How_to_Use_Filters_8203.mp4)<span style="color: #333333">). </span>For more information, see [WebFOCUS InfoAssist Manual 8.2.06](https://webfocusinfocenter.informationbuilders.com/WFDESIGNER/pdfs6/wfinfoasst.pdf)<span style="color: #333333">.</span>

## Related Articles

> Macro (contentbylabel)

> Macro (details)
> 
> | Related issues |  |
> | --- | --- |