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
            Updated: 13 Nov 2018 07:34 AM
            Helpful?  
            Help us to make this article better
            0 0