Custom Reports

 

The reports allow you to create customized reports from an SQL statement that is run on your database. You will be able to print the report to your screen to print it out or export it to a comma-delimited file for later use.

 

Clicking “Manage Reports” will enable you to add new reports or manage your reports that you can run.

 

When adding or managing a report, you have an option for a report title which is any title you want describing what the report is used for. You will also have an option for a SQL statement which is a query that brings up records to display on the report. After entering a SQL statement you can click the “Change” buttons to insert fields from the SQL statement you specified. You can also changed the header rows to fit your needs.

 

To print or export a report you select from the report dropdown on the main report screen and click the “Print” or “Export” button.

 

Add Feedback