Advanced Options

The Advanced Options menu is available in Advanced Reports and CrossTab Reports.

advancedoptions_menu.png

Note: If you do not have access to the Advanced Option menu or certain options within it, you may not have permission to do so. Please contact your administrator regarding permissions.

From the Advanced Options menu, the following items may be accessed:

 

Joins

If a report has two or more data categories, then information will only appear if the categories match. Using the Joins window, however, you may specify information you want to display regardless of whether or not it only exists in one of the data categories.

For example, if a report has two data categories, Orders and Customers, then only customers who have made orders will appear. By selecting the appropriate checkbox you can include information on customers that have not made orders.

screen.joins_window.png

The following options are also available within the Joins window:

 

Editing and Adding Joins

When either editing an existing join or adding a new join between two data categories that are not currently joined, the Report Join menu will appear.

screen.joins_editingexample.png

In this menu you can modify the information of a join or create a new join for the report.

Caution: There is no restriction on what fields may be joined. Please use careful consideration when joining fields, as improper joins may result in unexpected data output.

 

Events

Event handlers may be applied to the report by advanced users for additional functionality.

screen.events_window.png

The following options are available within the Events window:

Upon triggering the event—e.g., OnReportExecuteStart will be triggered at the start of the report's execution—the associated action will take place.

Note: For more information, please see the Server Events article.

 

Show Generated SQL

As of v2019.1+, advanced users may access the Execution SQL window via the Show Generated SQL option. This window displays the SQL statement that will be sent to the appropriate databases in order to execute the report.

screen.executionsql_window.png

The SQL statement shown in the Execution SQL window is the exact statement that will be sent to the databases. It is generated after applying sorts, filters, parameters, and other items that affect the constructed SQL.