Page Comparison

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.

...

1. The Constant selection from the Type dropdown, 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.  
      
      OR, 
      
      
   5. Retrieve all the available values from the database, by clicking the Get Values dropdown.
   6. Select an option from the dropdown.
   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 

Image Added

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 multiple values at run time. 

   3. Dynamic. This is used for prompts using Data Values. This option allows you to select multiple values at run time. 

      Tip
      You can also select Optional to indicate that the selected value (Simple, Static, or Dynamic) is optional when running the report.

      
      

Simple Parameter Filter 

1. For our example, we will use EMPLID. 
2. Select the Simple radio button.  
   Image Added
3. Enter text in the Description field exactly as you would like it to be seen by the person running the report.  
   Image Added
4. Click OK to confirm.  
   Image Added

Static Parameter Filter 

1. For our example, we will use ACAD_PROG_PRIMARY. 
2. Select the Static radio button. 
3. Enter text in the Description field exactly as you would like it to be seen by the person running the report.  

4. Enter the appropriate text in the Value field, and then click the double arrow to add to the Multiple Values: list on the right. 

   Note
   The Multiple Values list, to the right, represents the list of values the user will see in the dropdown for this parameter when running the report.   Image Added

   
   

5. Click OK. Image Removed

Dynamic Parameter Filter 

1. For our example, we will use Term Codes.  
2. Description - Enter text in this field exactly as you would like it to be seen by the person running the report.  
3. Dynamic
4. Select multiple values at runtime allows you to select multiple terms when running the report.  
5. Select Desending  - For these codes, sorting in Descending Order is recommended, as this allows the most recent term to appear at the top of the list. 
6. In the Search Fields section, select the field that is being filtered - this should match the text that displays in the Name field above.  
   
7. test

Related Articles

...