Select Optional Tables for Custom Reports (Advanced)

When creating a custom report you can select optional tables. If an optional table has no data for any records returned by the report, the table's selected columns are shown with no values. For example, if Direct Appraiser - User ID is selected as a column to show in a report that returns a list of learners, but you want to include learners who do not have a direct appraiser, you would select the Direct Appraiser table as optional. 

To select optional tables

1. In the Report Wizard, click Advanced. Additional steps are shown in the wizard's navigation bar.
2. Click Ext. tables. The tables you can select as optional are listed.
3. Select a table's check box to include rows in the report output that do not have a record in the table. Alternatively, clear its check box to exclude results where the table contains no data.
4. 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 Custom Report Columns to Sort on (Advanced)

Edit Custom Report SQL Selection Criteria (Advanced)

About Custom Reports