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. For our example, we will use EMPLID. 
2. Select the Simple 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. Click OK to confirm to confirm and return to the WHERE statement view.  
   

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.

   
   

5. Click OK . to confirm and return to the WHERE statement view.  

Dynamic Parameter Filter 

1. For our example, we will use Term Codes.  
2. Select the Dynamic 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. To allow selection of multiple terms at the time of running the report, check off multiple values at runtime.   
   
5. Select Desending, as the sort prompt order option.  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. Click OK to confirm and return to the WHERE statement view.  

Related Articles

...