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.
Note: Before you edit 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 a Database.
To add and edit the SQL, click on the SQL icon:
This opens a new screen that allows the SQL to be 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. Contact us for specialised help with this.
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.
Open the Custom Reports screen.
Note: Before you edit 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 a Database.
To add and edit the SQL, click on the SQL icon:
This opens a new screen that allows the SQL to be 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. Contact us for specialised help with this.
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.
Related Articles
Custom Reports
ustom reports can be written to meet a specific requirement. To view the custom reports window, from Admin mode choose Reports> Custom Reports This opens the custom reports screen showing all existing reports. Add New Report - Click here to add a ...Step 2 - SQL Update
Some upgrades may require changes to the database. If you are using a Microsoft Access database... Sit back! Relax! Your database will automatically update when you install with the new version. If your database is being held on an SQL server, then ...Adding a Custom Report
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: In the 'new record' (the blank record with '*' in the 'row selector') record ...Staff List
Staff details can be added and maintained in many different ways depending on how your VisitorRego unit is set up. The following knowledge base article looks at the Staff List page in VR Portal and provides instructions on how to add new staff, edit ...Pre-defined Custom Reports
As customers requests reports, we make them available to the VisitorRego community. If there is a report you need, request it and we will make it available to all via this web page. Contact our friendly VisitorRego support team with your request.