Transaction Reports

Transaction Reports allows you to review site activity based on specific criteria that you define. You can create one-time reports, print reports, or export reports in PDF format.

Transaction Reports has 3 pages:

The Card Holders, Optional Fields screen has an option - Include Deleted Cards. If you have to audit or investigate site activity for cardholders deleted from the system, enable this option. Format the 3 screens for the desired times, transaction types, and devices. Based on the selected parameters, the report will include deleted cardholder's transactions that occurred during the specified time period.

About Card Holders, Optional Fields

You may use a single field or multiple fields to specify card records in your report.

In text boxes, you can enter either the full name or the full number or a partial string of alpha or numeric characters. As an example, if you wanted to list all card holders whose last name has the letter M, type M in the Last Name field. When you select the Find Cards button, the search results will show all card records that contain an M anywhere in the last name.

Wild Cards

When listing card holders using the First Name or Last Name fields, please note the use of the (^) caret and (~) tilde characters as wild cards.

Open/Close Devices, Direction Page

To open or close the Devices, Direction page, click on the +/- symbols at the far right of the Devices, Direction heading.

Navigate a Multiple Page Report

The maximum number of transactions displayed on the page is 15. If your report produces more than 15 transactions, you will see a range of numbers displayed below the Transaction Reports heading. This indicates the total number of pages in the report.

The example above would indicate the report has produced a list of transactions that consists of 4 pages. The following parameters apply when navigating a multiple page report:

Overview

This page is used to specify the dates of the transactions, the transaction types, and how the transactions are sorted.

Date Settings presents three choices:

A Date Option is selected by clicking on the radio button to the left.

Date Range

If Date Range is selected, specify the From and To dates and, if applicable, the Start Time and End Time under Transaction Times.

Last # of Days

If Last # Days is selected, enter a numeric value to specify the number of days and, if applicable, the Start Time and End Time under Transaction Times.

One Day

If One Day is selected, specify the day and, if applicable, the Start Time and End Time under Transaction Times.

Transaction Types

In the Transaction Type panel, specify which transactions the report includes. You can select specific transaction types by clicking in the individual boxes to the left or you can select all transaction types by clicking in the box above and to the left of the Transaction Type heading.

Sorting Options

The Sorting Options panel lets you specify in what order the transactions are displayed:

This page is used to specify which card holders are included in the report. This can be a single card holder, a group of card holders or all card holders.

General Card Holder Information Fields

Use one or a combination of fields to specify which card holders are included in the report.

Optional Card Holder Information Fields

If defined in the Keyscan Client, use one or a combination of fields to specify which card holders are included in the report.

Find Cards

Displays cards based on parameters specified in General Card Holder Information Fields and Optional Card Holder information Fields. If no parameters are specified, when the Find Cards button is selected, the Search Results table will be empty. However,contingent on the date options and transaction types selected, all card holders will be listed when you run a report.

Clear Find

The Clear Find button, erases criteria specified in any fields.

Sort by field:

This option determines in what order the cards are sorted in the Search Results table.

Include Deleted Cards

This option lists any cards that were deleted during the specified period of the report.

Include Card Fields

When any of these fields are selected, they are included in the report. Please note, they are not shown in the Search Results table.

This page is used to specify an individual device, a group of devices, or all devices for either doors, elevators, auxiliary inputs, supervised inputs, auxiliary outputs or IOCB1616 inputs.

Door List

The Door List lets you specify which door(s) the transaction report includes. You can select specific doors by clicking in the box to the left of the Unit ID column or click in the box to the left of Door List to select all doors.

Auxiliary Inputs List

The Auxiliary Inputs List lets you specify which auxiliary inputs the transaction report includes. You can select specific inputs by clicking in the box to the left of the Unit ID or click in the box to the left of Auxiliary Inputs List to select all auxiliary inputs.

Auxiliary Outputs List

The Auxiliary Outputs List lets you specify which supervised outputs the transaction report includes. You can select specific auxiliary outputs by clicking in the box to the left of the Unit ID column or click in the box to the left of Auxiliary Outputs List to select all auxiliary outputs.

Elevator List

The Elevator List lets you specify which elevators the transaction report includes. You can select specific elevators by clicking in the box to the left of the Unit ID column or click in the box to the left of Elevator List to select all elevators.

Supervised Inputs List

The Supervised Inputs List lets you specify which supervised inputs the transaction report includes. You can select specific supervised inputs by clicking in the box to the left of the Unit ID column or click in the box to the left of Supervised Inputs List to select all supervised inputs.

IOCB Inputs

The IOCB Inputs lets you specify which inputs/outputs the transaction report includes. You can select specific IOCB Inputs by clicking in the box to the left of the Unit ID column or click in the box to the left of IOCB Inputs to select all inputs. Requires IOCB1616 circuit boards.

Direction

The Direction panel allows filtering the report based on a reader direction assignment when the report includes the Door List option. The reader direction can be set to the following settings:

Specify a direction by clicking inside the appropriate radio button, To view doors/readers set with In or Out, leave the default setting on All.

Procedures

  1. From the main page, select Transaction Reports.

  2. Select the Date Options and Other Settings tab if that page is not open.

  3. From the Date Options and Other Settings, specify the Date Option.

  4. To specify a day or dates click in the appropriate date field and adjust the calendar to the desired month and day. For Last # of days enter a value in the text box.

  5. If applicable, adjust the start and end times for the Transaction Times. You can click inside the hour, minute or second box and use the up or down arrows to increase or decrease the times.

  6. If applicable, select a Sorting Option.

  7. Select the Card Holders, Optional Fields tab at the top.

  8. From the Card Holders, Optional Fields page, select the appropriate criteria.

  9. If you specified card holder criteria in step 8 or you want all card holders listed in your report, click on the Find Cards button. (If you did not specify card holder criteria, click on the OK button in the warning box.)

  10. To the far right of the Devices, Direction title bar, click on the +/- symbol.

  11. From the Devices, Direction page, specify the devices to be included in the report.

  12. Click on the Run Report button.

  13. When you have reviewed the report, click on the Exit button.

  14. To return to the main page, click on the Exit button on the Transaction Reports button.

These procedures assume you are familiar with formatting and running a report. If you are not, click on the Format and Run a Report link to review the procedures.

  1. From the main page, select Transaction Reports.

  2. Format the report using the relevant criteria under Date Options and Other Settings, Card Holders, Optional Fields, and Devices, Direction.  

  3. Select the Run Report button. You may have to wait a few seconds while the report is compiled depending on the range of criteria specified and the volume of site transactions.

  4. From the Transaction Reports screen, select the Print button.

  5. From the Transaction Report pop-up page, click on the Print link.

  6. From the Print dialog box, if applicable, make the necessary printer settings.

  7. Click on the Print button.

  8. From the Transaction Report pop-up page, click on the Exit link.

  9. From the Transaction Reports page, click on the Exit button.

  10. To return to the main page, select the Exit button on the Transaction Reports formatting page.

These procedures assume you are familiar with formatting and running a report. If you are not, click on the Format and Run a Report link to review the procedures.

  1. From the main page, select Transaction Reports.

  2. Format the report using the relevant criteria under Date Options and Other Settings, Cardholders, Optional Fields, and Devices, Direction.  

  3. Select the Run Report button. After selecting the Run Report button, you may have to wait a few seconds while the report is compiled depending on the range of criteria specified and the volume of site transactions..

  4. From the Transaction Reports page, select the Export to PDF button.

  5. From the Export to PDF dialog box, right click on the Download Report link and select Save Target As.

  6. From the Save As dialog screen, navigate to the folder where you want to save the PDF version of the report.

  7. By default the application inserts the logged on user name and the date in the File Name field. You can either accept this as the file name or re-name it.

  8. Click on the Save button.

  9. From the Download Complete dialog box, select the Close button.

  10. If you selected Close in the previous step, click on the OK button in the Download Report dialog box.

  11. From the Transaction Reports page, select the Exit button.

  12. From the Transaction Reports formatting page, select the Exit button to return to the main page.