Contents
 Welcome
 Common Terms
    Terms
 Quick Start
    Pre-Installation
       .NET Framework
    Quick Install
    First Visitor
    Leaving
    Emergency
 Getting Started
    How to Get Support
    Online Information
    Implementation Options
 Setup and Maintenance
    Data - Company Specific
       Maintain Site
       Maintain Departments
       Maintain Staff
          Loading Staff – Active Directory
          Loading Staff – Excel
    Data - Visitor Specific
       People
       People - navigating
       Visitors Company
       Visitors Company - navigating
       Register
       Register - navigating
    Registration Screen
       Registration Setup
       Field Description
       Placing Fields
       File Locations
    Communication
       Email Notification
    Connecting and Installing Peripherals
       Printer Label
       Printer Plain Paper
       Label Printer Maintenance
       Scanner
          USB Mode
          Serial Mode
          Bar Code
       Webcam
    Setting up Database
       Creating the SQL Database
       Connecting to Database
 Self Registration
    Self Registration Setup
    Registering
    Customizing Graphics
    Features
       Tuning Features On or Off
 Messaging
    Broadcast Message Setup
    Individual Message Setup
 Report Builder
    Label editor
    Data Fields
    Objects
       Properties
 Custom Reports
    Adding a Custom Report
    Add and Maintain SQL
    Pre Defined Custom Reports
       Appointments
       Safety Induction Expiry
       Supplier Summary
       Supplier Summary - Detail
       Supplier - By Rep
       Visitor by Company
 Appointment/Pre Registration
    Make an Appointment
    Appointments
 Contractors
    ID Printer Setup
    Issue Pass
    Pass Template
    Safety Induction Enabled
    Entering Safety Induction
    Entering Safety Induction - Alternative
 Advanced Features
    Select Data to copy to Excel
    Paste data to Excel


LinkIndexBookmarkPrint
Home > Report Builder > Data Fields

Data Fields 

In order to use data from the database in VisitorRego.NET reports there are several reserved ‘Data IDs’ used to link useful data to the report righter.

To link data simply add the corresponding ID to the ‘Data Field’ Property under the properties panel on the right hand side of the Report Builder e.g. imgID.

SCREEN SHOT

Below is a list of the ‘Data IDs’ and their corresponding data.

RegisterID

Holds the numeric database ID that numbers each visitor.

SiteID

Holds the numeric database ID that numbers each site.

NameID

Holds the numeric database ID that numbers each visitor based from their name.

RegisterName

Contains the name of the visitor.

Company

Contains the name of the company the visitor belongs to.

Vehicle

Holds the registration number of the visitor’s vehicle.

Phone

Holds the phone number for the visitor.

Email

Holds the email address of the visitor.

PostalAdress

Contains the postal address of the visitor.

DeliveryAddress

 

MeetingWith

The person that the visitor is meeting.

StaffID

Contains the numeric ID for staff members based of their name.

TimeIn

The date and time the visitor signed in.

TimeOut

The date and time the visitor signed out.

MeetingLocation

The location where the visitor will be meeting.

AccessCard

 

AccessCardReturned

Specifies wether the visitor manually signed out or was signed out by the system after the access time has expired.

[In]

Holds a value to specify wether the visitor has signed in 1 being yes, 0 being no.

Out

Holds a value to specify wether the visitor has signed out  1 being yes, 0 being no.

DateHealthSafety

 

SafetyInduction

 

DateVideoViewed

 

Lastname

Holds the last name of the visitor.

Firstname

Holds the first name of the visitor.

DisplayID

Contains the system generated ID that is used for barcodes.

SpecialInstructions

 

RemoteDBUpdated

 

WorkStationName

Holds the name of the area they signed in from e.g. Reception.

imgID

Used for the purposes of photo registration. Contains the photo of the visitor.




See also
Label editor
Objects



  

 
Article Details
Created:5/02/2010 11:17:46 a.m.
Modified:22/02/2010 12:50:37 p.m.
Author:Admin
Views:24

Options
 Print Article
 Bookmark Article
 Link to this Article

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.