Announcement

Collapse
No announcement yet.

Using queries in report

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Using queries in report

    I have created some complicated queries in Navicat, but I am unable to access those queries when creating report. The query wizard only shows tables and views. How can I create a report from a query? Please help…

  • #2
    To create a data pipeline using query SQL:
    1. Select Data tab > File > New > Query Designer.
    2. In the Query Designer, select SQL tab.
    3. Right-click the gray and choose Edit SQL.
    4. Copy the SQL statements from your query to the SQL tab.
    Notes: If you change the SQL manually, you cannot use the visual design tabs (Fields, Calas, Group, Search and Sort) to modify the query.
    Attached Files

    Comment

    Working...
    X