Summary:
It would be extremely useful to have a “Show SQL” button available for both ad-hoc and saved reports in SimplyReports.

Background and Problem:
There are currently well-known workarounds that allow users to view or reconstruct the SQL generated by a report, but they’re tedious and time-consuming. These methods often involve extra steps like exporting report definitions, or having to view the page source after scary looking resubmission warnings. For users who need the SQL quickly, these barriers can be a significant slowdown.

Proposed Solution:
Add a “Show SQL” button directly in the report interface—both for ad-hoc reports and saved reports. When clicked, it would display the underlying SQL that SimplyReports is generating for that report.

Benefits:
• Faster customization: Users could take the generated SQL and adapt it for their own use cases that SimplyReports doesn’t natively support.
• Integration with other tools: Users could copy the SQL and use it in external systems like FindTool SQL searches or other analytical environments.
• Reduced support burden: Empowering users to self-serve their SQL needs would reduce the number of requests for special report modifications.

Additional Considerations:
• Ideally, it should be formatted for readability.
• An optional download or copy-to-clipboard feature would enhance usability even further.

Keywords for searching: Simply Reports