Adding a Custom Report

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 enter the following:


Report Name:

The name of the report. There is no restriction on this name. It describes the report.

Report Template:

The name of report template file. This file holds the language that formats the data. This language is called xml. The report template is designed and maintained by the report designer. The report designer gives a user friendly means of writing xml. To design a report click on the button 'Design' to open the report designer. Please refer to Report Builder for a full description on the report designer.

SQL Description:

A description of the SQL. There is no restriction on this name. It describes the underlying SQL.

Close and reopen this screen to define the new custom report.

Hint: The best way to create a new custom report is to take an existing report - and change it to meet the requirement.

Hint: Writing SQL is not for the faint hearted! It should only be attempted by competent database expert.
    • 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 ...
    • 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.
    • Hazard Reports

      A new feature in VisitorRego Version 8.278 is the Hazards Reports Screen. Visitors, contractors and staff members can now report on a hazard when they sign out!  Requirements: To utilise this new feature you need to be running VisitorRego V8.277 or ...
    • Report Builder

      VisitorRego contains a fully functional Report Builder used in the creation of templates utilised by VisitorRego to print off data for such purposes as: Label Printing Emergency Register Sheet Visitor History   The Report Writer gives VisitorRego the ...
    • How to Get Reports using VR Portal

      Sign into the website and navigate to the Register tab and select Today+ from the drop down menu This will show you the details of everyone who has signed in and out. From here you can filter and search the registrations then export reports to Excel ...