Specify report restrictions
You can restrict a report to data that meets a specified condition by using a SQL WHERE clause. For example, you might want the report to include only males who reside in the United States and are between 18 and 55 years old. The application applies the report restriction, if specified, after generating the report, but before displaying the report.
For an interactive report, the query run as part of the report determines which cases are included in the report. A SQL restriction, on the other hand, acts on the data for those cases. For example, suppose you want a report that shows drug counts for only suspect drugs. If you include a suspect drug indicator as a query variable, the report runs against all cases including suspect drugs. Some of these cases might also have non-suspect drugs. However, you could specify a SQL restriction to include only suspect drugs in the report.
Note:
Columns of the type CLOB are truncated in reports. Therefore, if a column referenced in the restriction has the type CLOB (as is typical with narrative text), the application applies the restriction to the truncated values for that column.Parent topic: Specify report attributes/descriptors