In this section: |
After selecting field values for the X and Y axes, you may wish to limit the data that appears in your graph. You can do this by creating WHERE statements. A WHERE statement limits data by creating parameters the data must satisfy before it is included in the data set.
For details on creating WHERE statements, see Writing Expressions With Graphical Tools in the Creating Reports With Report Painter manual.
The following image shows the Expression Builder and a sample WHERE statement.
When generating a report and specifying which fields to display, you may not want to show every instance of a field. By including selection criteria, you can display only those field values that meet your needs. You can select a subset of the data, which you can easily redefine each time you issue the report request.
When developing a report request, you can define criteria to select records based on:
The Selection criteria tab enables you to create Where or Where Total statements for record selection.
WebFOCUS |