Creating Query Pages

Each SQL report file can contain one or more pages for creating queries and showing query results.

You can create, reorder, and rename query pages and remove query pages from reports.
  1. In an SQL report, do one of the following:
    • Select Report > Settings
    • Select Settings: Settings
    • On the keyboard, press Ctrl and R.
    The Report Settings dialog appears.
  2. On the SQL tab, select Add.
    Enter Query Name
  3. Enter a name for the query and select OK.
    The query name appears in the Report Settings dialog and a tabbed page for the query appears in the SQL report screen.
    Report Settings
  4. Select Close.
    You can now enter a SQL statement in the query box on the query page.
  5. Select Save: Save