How can I create a report based on a query?
Apply OS: Windows
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All
You can use your custom queries when designing your report. To use your own query:
- Choose Data tab in the Report Design view.
- Select File > New.
- Choose Query Designer > SQL tab.
- Right click on the grey text area, select Edit SQL.
You can then type in (or paste) your own SQL statement in it. You are also required to give a name to your SQL in the Name textbox above. Then the report will be based on your own SQL statement.
Note: If you change the SQL manually, you cannot use the visual design tabs (Fields, Calcs, Group, Search and Sort) to modify the query.