Creating Selection Criteria (WHERE Statements) in Reporting Objects

WHERE statements or selection criteria, restrict the data retrieved to only those records that meet the conditions that you specify. Filters are selection criteria that run when the user selects the filter in WebFOCUS. Other selection criteria run when the user opens the Reporting Object, preventing data values that do not meet the criteria from being available to the user.

For more information on WHERE statements, see Field Tab in the WebFOCUS InfoAssist User's Manual.

Procedure: How to Create Selection Criteria

1. Right-click the Where Statements component and select New, or select the component and click New on the ribbon.

   The New Filter dialog box opens.

2. Double-click the red text or press F12 to edit the WHERE statement.

   For more information on creating selection criteria, see the Using Filters to Customize the Display of Data topic in the WebFOCUS InfoAssist User's Manual.

3. When you have created the selection criterion, click OK to return to the Reporting Object tool.