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
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 ...How to Add Staff Using VR Portal
Step 1. Navigate to the Staff > Staff tab Note: If you are managing multiple sites select which site you wish to add the staff member. Click on the dropdown menu next to ‘Staff’ and select which site you wish to view. Step 2. Click the icon to add a ...Adding a Contractor
There are three different ways to add contractors to the VisitorRego Portal From the contractor list From a contractor company If the contractor has already signed in Adding a contractor from the contractor list The Contractors> Contractors tab ...Adding an Additional Field to the Label
Adding an additional field to the visitors label for example, car registration, can be edited in Visitor Rego. Navigate to Options > Registration setup to find the database field. The database field for car registration is called‘Vehicle’. Navigate ...Advanced Contractor Management - Creating an Access Template
The following article details Advanced Contractor Management (Access Levels), it is advisable that you use Permits instead, which is a straight forward, easy induction process. Click here for an article explaining Permits. Navigate to the Access> ...