Interlogix Topaz User Manual - Manual (Page 175)

Chapter 7
Reports
157
Available Fields Select which fields you wish to appear on the report, in the order you wish them to appear from left to
right, by selecting a field and clicking the right arrow. This moves that field name to the Selected
Fields on the right.
Note: Do not select the same field you are sorting by. If you do, this duplicates that field on the
report. The field you sort on will be the first field on the report.
Selected Fields If you wish to remove a field from the Selected Fields, select it by clicking on it, and then click the left
arrow. This moves that field name to the Available Fields on the left.
Photos per Page You can select up to 24 photos to be printed on one page on a printer. This option only applies if Print
Photos is selected.
Filter By The Filter By, Condition, and Value fields enable you to specify criteria to select certain records in the
Employee database. You may select up to two filters for a report. Select a field from the left-side Filter
By drop-down list, for example, ACTDATE (the employee's card activation date).
Condition If you use a data field for Filter By you can apply a condition to the information in that data field. Using
the previous example, you might choose “Greater than or equal to”.
Value You can specify a value for the data field in Filter By. Using the previous example, you might choose
“19991001” as the first of October 1999. Date format must be (YYYYMMDD).
The above filtering produces a report listing all employees who have a card activation date of Oct. 1,
1999 or later. You can also specify a second filter, such as Filter By “ACTDATE”, Condition “Less
than”, and Value “19991101”. The combination of both filters lists only employees whose cards were
activated in the month of October of 1999.
Note:
• When filtering by Security Area, use “Greater than or equal to” for the condition and the number
“2” for the value. This recalls all cardholders authorized for the area in the filter by field. Access to
an area is controlled by assigning a Time Schedule number (0-126) to the Security Area Name in
the cardholder’s record. The numbers 0 & 1 deny access, so any number, 2 or greater, indicates
that the employee is allowed access to the selected security area.
• When filtering by an Access Group, select the name of the Access Group from the drop-down list
in the Filter By field. Use “Equal” for the condition and leave the value field blank. This recalls all
cardholders authorized for the group in the filter by field. When “Not Equal to” is selected for the
condition, this recalls all cardholders who are NOT authorized for the group in the filter by field.


If the value entered into the Value field is not the correct format for the data in the Filter By field, a
“File Not Found” error message displays when saving the report.
Print Photos Click to print the selected employees on the Photo Badging printer that is selected in “Hardware –
Workstation”. No report displays on the screen. The printed photos print along with the Card Number
and Card Name.
Display Report This is the default. Click to display on the Workstation monitor.
Print Report Click to send to the report printer.
Output To File Click to save the report into the file name specified in the Output File Name field. This saves the
report results in a file for later use outside of Topaz.
Output File Name If you selected Output to File, enter the name of the file to contain the report information. The Output
File Name can have up to 64 characters. For example, you can type “Myreport” and the report is
saved into the file named Myreport in the directory where Topaz was installed. You may enter a path
with the file name, for example, “c:\reports\Myreport”. The format of the report files is always plain text
that can be opened in Notepad.