Edit Custom Report SQL Selection Criteria (Advanced)

When creating a custom report you can append additional filter criteria to the SQL WHERE clause to create ad hoc filters. You can also update the WHERE clause itself, which reflects the filters selected in the Filters page of the Report Wizard. The SQL statement shows you the tables you can use for your filters.

To edit the SQL for selection criteria

1. In the Report Wizard, click Advanced. Additional steps are shown in the wizard's navigation bar.
2. Click Edit SQL. The SQL SELECT statement for the report is shown, along with the SQL for the filter.
3. Enter your additional filter criteria in the bottom, editable text box. Start with AND.
4. Optionally, select the check box to edit the original filter criteria (the WHERE clause).
5. Click Save.

Additional Information

Create a Custom Report

Select Custom Report Columns

Select Custom Report Grouping Information

Select Custom Report Column Order

Select Custom Report Column Filters

Select Optional Tables for Custom Reports (Advanced)

Select Custom Report Columns to Sort on (Advanced)

About Custom Reports