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 > Custom Reports > Adding a Custom Report

Adding a Custom Report 

To add a new custom report you need to tell VisitorRego how to retrieve the data from the database and how to format this data in a report.

Open the Custom Reports screen

In the 'new record' (the blank record with '*' in the 'row selector') record enter the following:



Report Name:

The name of the report. There is no restriction on this name. It describes the report.

Report Template:

The name of report template file. This file holds the language that formats the data. This language is called xml. The report template is designed and maintained by the report designer. The report designer gives a user friendly means of writing xml. To design a report click on the button 'Design' to open the report designer. Please refer to Report Builder for a full description on the report designer.

SQL Description:

A description of the SQL. There is no restriction on this name. It describes the underlying SQL.

Close and reopen this screen to define the new custom report.

Hint: The best way to create a new custom report is to take an existing report - and change it to meet the requirement.

Hint: Writing SQL is not for the faint hearted! It should only be attempted by competent database expert.   




  

 
Article Details
Created:11/10/2010 11:16:32 a.m.
Modified:12/10/2010 1:08:22 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.