x

1. Click the Data selection tab.
2. Click the Filters icon in the query pane below the Available Fields tab.
3. Double-click the field in the Available Fields list that you want to use for filtering data.

   or

   Drag the field in the Available Fields list into the pane below the graph preview area.

4. In the pane below the graph preview area, select WHERE or WHERE TOTAL from the drop-down list on the left.

   The following image shows the result of adding the REGION field to a filtering expression in the pane below the graph preview area.

   

   When you have more than one filtering expression, the drop-down list on the left has OR and AND as valid selection values, in addition to WHERE and WHERE TOTAL.

5. Select an operator (for example, EQUAL to) from the drop-down list on the right.

   The following image shows the list of available operators you can use.

   

6. Click the Select Value button.

   The Select Value dialog box opens, as shown in the following image.

   

7. Select one of the following options in the Select Value dialog box to provide the value for the filtering expression you are creating:
   • Constant. When you select the Constant value option, enter a value in the input area to the right.
   • Parameter. When you select the Parameter value option, click the ellipse button (...) to the right to open the Variable Editor dialog box, which is used to create a parameter for the filtering expression. For details, see Setting Parameter Properties.
   • Field. When you select the Field value option, a list of the available fields in the selected data source appears in the area to the right. Click to highlight the desired field.
   • Values. When you select the Values option, a list of valid data source values associated with the field you selected appears in the area to the right. Click to highlight the desired field value.
8. Click OK and the WHERE or WHERE TOTAL filtering expression appears below the graph preview area.

   For example, if you selected the Constant option and entered Espresso as the value, the expression would appear, as shown in the following image.

   

x

1. Navigate to the Data selection area.
2. Begin creating a WHERE statement by selecting a field from the list of Available Fields.
3. Select a data comparison option that can accept multiple values.

   Valid options include EQUAL to, NOT EQUAL to, IN literal list, NOT IN literal list, EXCLUDES literal list, and INCLUDES literal list.

4. Click Select Value.

   A dialog opens to select values.

5. Click the import button, as shown in the following image.

   

   A dialog box opens, as shown in the following image.

   

6. Select one of the following File Format options:
   • Flat file
   • Excel Spreadsheet (XLS)
7. Click the Browse button.

   A standard file selection dialog opens.

8. Select an external file to import from your local machine or network.

   Note: The external file must only contain text with new line delimiters.

9. Click OK.

   The values contained in the file are displayed in the Multiple values entered list in the right pane of the values dialog.

10. Optionally, you can remove specific values from the Multiple values list or move values up or down within the list.
11. Click OK.

    You can save the query for future use and reopen the query to append new or remove existing values.

x

1. When the Variable Editor dialog box opens, enter appropriate text in the Name and Description fields for the parameter.

   These fields may be automatically filled in based on the field you selected to create the filtering expression.

2. Choose from the following Selection options:
   • Dynamic. The Dynamic option is the default selection. The Data Source and Field values, which you may change as needed, are selected by default based on the field you selected to create the filtering expression. Note that when working with a Reporting Object, you can only select fields from data sources the Reporting Object is defined to access.
   • Static. The Values area at the bottom of the Variable Editor is activated. Select the Constant or Value option. For constant, enter a value or values. For the value option, all of the values for the selected field appear in the Value list box. Move the values you want to the Multiple values entered area using the plus minus buttons.
   • Simple. If you want to create a simple prompt to appear in the Auto Prompting facility, enter a name in the Parameter field that will be used as the parameter prompt. A Simple parameter prompt provides a text box in the Auto Prompting facility for the user to type a parameter value. The following image shows an example of a value in the Parameter field:

     

   • Select multiple values at run time. With the dynamic or static options, you can select to be prompted for multiple values at run time.

   The following image shows the Variable Editor dialog box.

   

3. Click OK to exit the Variable Editor dialog box.
4. Click OK to exit the Select Values dialog box.

x

1. Create an expression (WHERE or WHERE TOTAL statement). For detailed instructions, see How to Filter Data Based on Values, Parameters, Fields, or a Constant.
2. When you create additional expressions, they are combined with the default operator AND, as shown in the following image, which displays two statements, the first beginning with WHERE and the second with AND.

   

3. Select AND or select OR using the drop-down list for all additional expressions added after the first WHERE or WHERE TOTAL statement.

Note: You can click any of the gray (inactive) parentheses to activate them and group sections of an expression together to optimize your ability to filter data. Parentheses should always be used in pairs.

x

1. Select the check box next to the expression you want to delete.
2. Click the Delete icon above the box.
3. When you are prompted to delete the expression, click OK.