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. Right-click on a field from the left Search fields 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" dropdown 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.
   
   
8. Then click the "Value" dropdown arrow to display a list of additional options.
   
   
   

9. From the Value dialog box, click the Type dropdown 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. Will be documented in future documentation, more to come.  
      
      
      

...

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

...