Tools (Query Builder)
The Tools tab provides useful information for advanced query authors. The Tools tab becomes active once a query is valid:
• A name has been specified on the Properties tab
• At least one table or report template has been added on the Tables and Joins tab
• At least one reportable item has been added on the Select or Constrain tab
 |
The Tools tab is only visible when the > > preference is set to Yes in the Preference Management utility. For more information, see Preference Management.
|
The following actions are available from the Tools tab:
|
Action
|
Description
|
|---|---|
|
View QML
|
View the latest QML (query markup language) for the report template. The QML can be copied out of this view and pasted elsewhere to share with others.
|
|
View SQL
|
View the SQL that is generated for the report template QML.
|
|
Preview Report
|
Displays a quick preview of the report output. Useful to quickly preview the results as you are adding tables and joins. The number of rows displayed in the preview is limited by the > > preference in the Preference Management utility. The default value for the Preview Row Limit preference is 200 rows.
To see the complete report output, use the View Report action. Note that while the Preview Report action includes unsaved changes, the View Report action runs against the latest saved changes.
|