|
| | |
|
Home > Custom Reports > Pre Defined Custom Reports > 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 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
|
|
| Article Details | Created:7/12/2010 10:17:41 a.m.
Modified:7/12/2010 10:51:31 a.m.
Author:Admin
Views:3
| |
| Related Articles |
| |
 |
To add links, place the cursor in the box above and then click 'Link Page' on the toolbar.
| File Attachments |
| |
|
To upload and insert attachments, place the cursor in the box above and then click 'Document Manager' on the toolbar.
|
|
| |
|
|
Page URL: