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.