The underlying SQL for a report is edited easily within the Report Editor interface in the "Command Text" section.



The editor within QuickReportz includes SQL syntax highlighting and can also be expanded to a full screen view by pressing the F-11 key.  The above example will return a list of reports in the QuickReportz database and is all that is needed for complete working report.  Reports can accept user input by adding and defining parameters in the section above the "Command Text" and utilizing these parameters within the SQL statements.


The above example demonstrates how a string parameter has been added to the parameter list and is then utilized to enhance the SQL to support searching by report name.


Click here to learn more about all the parameter types available and to use then within your SQL statements


View SQL generated by QuickReportz when executed

When a report is executed by the report consumer QuickReportz generates a SQL statement based upon the defined parameter types along with some additional metadata.  For debugging purposes it is sometimes useful to access this SQL and execute it directly in another tool such as SQL Management studio.  Report Editor user types can access this generated SQL by clicking the "Show SQL" after executing a report from the view screen (shown below).  




Click here to learn more about the generated SQL and it's usage.