Announcement

Collapse
No announcement yet.

Import Query into Report Builder

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

  • mmcphail
    started a topic Import Query into Report Builder

    Import Query into Report Builder

    I was wondering if there was a way to import a query into the report builder. I have a more complex query that's using subqueries, table aliases, and pivots and that I would like to turn into a report. If there isn't a way to import, could someone guide me in the right direction to help create my query using the Query Designer or Query Wizard in the report builder?

    Thanks!

  • mayho
    replied
    Hi Robert,

    Would you please provide us screenshots or video showing the problem? You can send it to our support center - https://help.navicat.com/hc/en-us/requests/new

    Leave a comment:


  • CandD
    replied
    I select Edit SQL, get the warning, answer yes.
    At this point I can type but I cannot copy/paste.

    Robert

    Leave a comment:


  • mayho
    replied
    Hi Robert,

    Please refer to the screenshot below. If you still have problem, please provide us screenshot showing your issue.

    Click image for larger version

Name:	screenshot.png
Views:	1
Size:	42.5 KB
ID:	4629

    Leave a comment:


  • CandD
    replied
    I am trying to do this and it will not let me paste the query. Right click in the SQL area gives me no options.

    premium - 11.2.16

    Thanks
    Robert

    Leave a comment:


  • mayho
    replied
    If you want to create a report based on a query, please follow steps below:

    1. In Report, select Data tab > File > New > Query Designer.
    2. In the Query Designer, select SQL tab.
    3. Right-click the gray area and choose Edit SQL.
    4. Paste the query.

    Notes: If you edit the SQL, you cannot use the visual design tabs (e.g. Fields, Calas, Group, Search and Sort) to modify the query.

    Leave a comment:

Working...
X