|
| | |
|
Home > Custom Reports > Add and Maintain SQL
Add and Maintain SQL
To add a new custom report you need to tell VisitorRego how to retrieve the data from the database and how to format this data in a report.
Open the Custom Reports screen
To add and edit the SQL, click on the words of the SQL Description i.e. in the example below, click on the words 'Appointment between date range'.
Note: Before you edit the the SQL you need to know the database engine used - either Microsoft Access or Microsoft SQL. There are subtle differences between the two that need to be coded for. To find out which database engine is being used, please refer to Connecting to Database
This opens a new screen that allows the SQL to entered and maintained.
As can be seen - SQL is not for the faint hearted. There is no expectation for a customer to become an SQL expert. At Visitor Registration Ltd we are.
The next section Pre Defined Custom Reports allows the copying of existing report templates and the SQL to extract the data for these reports. If there is not already an existing report that tells us then we can build the report template and SQL and distribute via the Knowledge web site.
|
|
| Article Details | Created:11/10/2010 4:24:03 p.m.
Modified:12/10/2010 2:44:09 p.m.
Author:Admin
Views:17
| |
| Related Articles |
| |
 |
To add links, place the cursor in the box above and then click 'Link Page' on the toolbar.
| File Attachments |
| |
|
To upload and insert attachments, place the cursor in the box above and then click 'Document Manager' on the toolbar.
|
|
| |
|
|
Page URL: