Adding a Custom Report
Custom Reports in VisitorRego's Admin Mode allow you to generate reports tailored to specific needs. You can choose from several pre-configured reports or create your own by configuring a report template and specifying the SQL query for data retrieval.
To add a new report, click on the Add New Report button in the top left corner of the window.
A new line will appear, allowing you to enter the details of the new report.
You will then need to enter or modify the following details:
Report Name:
The name of the report. There is no restriction on this name. It describes the report.
Report Template:
The name of the report template file. This file defines the appearance and layout of the report. The template is designed and maintained using the Report Builder, a user-friendly interface that allows you to customise the report. To design or modify the template, click the Design button to open the Report Builder. For detailed instructions, please refer to the knowledge base article: Report Builder.
SQL:
The SQL query used to generate the report. To input or modify the query, click the SQL button to open the window where the query can be entered. There are no restrictions on the name or content of the query, but it should accurately define the data required for the report.
Report Name:
The name of the report. There is no restriction on this name. It describes the report.
Report Template:
The name of the report template file. This file defines the appearance and layout of the report. The template is designed and maintained using the Report Builder, a user-friendly interface that allows you to customise the report. To design or modify the template, click the Design button to open the Report Builder. For detailed instructions, please refer to the knowledge base article: Report Builder.
SQL:
The SQL query used to generate the report. To input or modify the query, click the SQL button to open the window where the query can be entered. There are no restrictions on the name or content of the query, but it should accurately define the data required for the report.
The most effective way to create a new custom report is to start with an existing report template and modify it to meet your specific requirements.
Related Articles
Custom Reports
Custom Reports in VisitorRego's Admin Mode allow you to generate reports tailored to specific needs. Several pre-configured reports are available, or you can create your own custom reports to suit your unique requirements. To generate Custom Reports ...Report Builder - Label Template Designer
The Report Builder is a tool within VisitorRego that is primarily used for creating and editing visitor label templates, which are printed during sign-in. It offers flexibility for customising elements like logos, text, and fields on the labels. ...Hazard Reports
VisitorRego’s Hazard Report feature enables anyone who signs in to report hazards when they sign out. This ensures that safety concerns are promptly documented and addressed. This article provides instructions on how to report hazards during ...Authorisation Expiry Reports - An Overview
Authorisation Expiry Reports provide Site Administrators with information about authorisations that are due to expire, have expired, or are not yet certified. Automatically generated and emailed every Monday, these reports help Site Administrators ...How to Get Reports using VR Portal
To view sign-in records and export reports in VR Portal, use the Sign-Ins by Workflow page. From there you can: Filter by date range Search by name or organisation Export data to CSV, PDF or Excel View sign-in details including who signed in, when, ...