Apply OS: Windows

Apply Navicat Product: All

Apply Navicat Version No.: All


You can use your custom queries when designing your report. To use your own query:

  1. Choose Data tab in the Report Design view.
  2. Select File > New.
  3. Choose Query Designer > SQL tab.
  4. 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.

Have more questions?
Submit Ticket