Open for Voting

Ability to view/show "SQL Query" on Orion Web Based Reports

Earlier Report Writer tool we have ability to see the SQL Query after we design a report in Report Writer, the same feature if provided in Web Based Reports will be very helpful and powerful.

With this feature we will know behind the scenes what SQL query is generated for a report, which can be used to customize the reports more.

Old Report Writer:

To view the SQL content of Report Writer Origin report - you can still view it on Report Writer (RDP to Orion Server >> Open Report Writer >> select the report >> Report (menu bar) >> show SQL)

Refer the thread to understand this idea:

How can I get the SQL used to generate a report now that we have migrated to the web based report writer?