Visitor by Company
Report Name: Visitor - By Company
Report Template: VisitorByCompany.xml
SQL Description: Specific Visitor (Edit the SQL - and enter the name of the visitor)
This report shows a specific 'Visitor Name' showing all registrations made by the visitor, their company and the duration on site over a selected date range.
Below is an example of this report:
To add this report and make it available please refer to Adding a Custom Report.
This report requires the SQL to be edited, with the name of the visitor to report on i.e. to report on the company 'John Peat' then SQL needs to be changed from 'Visitor Name' to 'John Peat'.
Microsoft Access (click on the link below to open a screen with this SQL, copy and paste into the SQL window):
Visitor By Company (Access).txt
Microsoft SQL (click on the link below to open a screen with this SQL, copy and paste into the SQL window):
Visitor By Company (SQL).txt
Report Template (Right click the link below - then 'Save As' to your 'c:\Program Files\VisitorRego.NET\Res' directory:
Visitor By Company
Report Template: VisitorByCompany.xml
SQL Description: Specific Visitor (Edit the SQL - and enter the name of the visitor)
This report shows a specific 'Visitor Name' showing all registrations made by the visitor, their company and the duration on site over a selected date range.
Below is an example of this report:
To add this report and make it available please refer to Adding a Custom Report.
This report requires the SQL to be edited, with the name of the visitor to report on i.e. to report on the company 'John Peat' then SQL needs to be changed from 'Visitor Name' to 'John Peat'.
Microsoft Access (click on the link below to open a screen with this SQL, copy and paste into the SQL window):
Visitor By Company (Access).txt
Microsoft SQL (click on the link below to open a screen with this SQL, copy and paste into the SQL window):
Visitor By Company (SQL).txt
Report Template (Right click the link below - then 'Save As' to your 'c:\Program Files\VisitorRego.NET\Res' directory:
Visitor By Company
Related Articles
Visitor History
The Visitor History report in VisitorRego's Admin Mode allows you to generate detailed reports of all visitor registrations within a specified date range. The report provides an overview of all sign-ins and sign-outs that occurred during the defined ...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 ...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 ...Emergency reports via Admin Mode
VisitorRego includes an Emergency Report feature that enables you to quickly generate a list of all registered people on-site in case of an emergency. This article provides instructions on how to generate the Emergency Report using Admin mode. If you ...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 ...