Announcement

Collapse
No announcement yet.

Import Query into Report Builder

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

  • 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!

  • #2
    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.

    Comment


    • #3
      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

      Comment


      • #4
        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

        Comment


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

          Robert

          Comment


          • #6
            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

            Comment

            Working...
            X