Using ReportsMaestro
Working with report/chart builder
Creating web report
Creating web chart
Adding header and footer
Changing visual style
Custom SQL
Chart types
List of chart types
Accumulation chart
Area chart
Bubble chart
Column/Bar charts
Combined chart
Financial OHLC/Candlestick charts
Gauge chart
Line/Spline/Step-Line charts
Pie/Doughnut charts

Custom SQL


A user with admin permissions (admin) can create custom SQL queries that later may be used by other users as a datasource for reports and charts. Also admin can edit and delete custom SQL queries.

To view/create/edit/delete custom SQL queries use the Custom SQL button on the start window.


To create new custom SQL query:

1. Click the Custom SQL button on the start window.

2. Click the New button.


3. Enter SQL query name and the query code. If you wish to set permissions for the created query right after its saving, check the Proceed to permissions screen check box. Note that you can set permissions later on the Admin page (use the Admin page button on the start window).


Note that you can use stored procedures in the SQL query for those databases where they are supported (MS SQL Server, MySQL, Oracle, etc.).

Example of calling the stored procedure without parameters in MS SQL Server:

EXEC [Ten Most Expensive Products]

Example of calling the stored procedure with parameters in MS SQL Server:

EXEC [Employee Sales by Country] '10/10/2007','10/10/2009'

4. Click Save.

When creating a report or chart a user can choose custom SQL query as a datasource (go to the SQL queries tab on the Tables window). Admin can also create new custom SQL query using the New query button and edit the existing SQL queries using the SQL Query button.



Converted from CHM to HTML with chm2web Standard 2.85 (unicode)