Visitor by Company

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
    • 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 ...
    • 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 ...
    • 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 ...
    • Emergency reports via Admin Mode

      Emergency Reports via Admin Mode       In Admin Mode simply click on the 'Emergency' button located along the top menu bar of the window. Below is a print preview of the list of visitors that will print. Choosing where your Emergency Report is ...