Reporting Tab

The Reporting tab in Web Client provides predefined reports that allows you to easily obtain various kinds of information about the hardware components, software configuration, people, and event\alarm history of your physical access control system.

Reports based on Criteria

The reporting based on criteria list pane is customized with Boolean expression using AND/OR arguments to include or exclude clauses without the expression.

Before you start editing the Boolean expression, make sure that you understand the basic logical operation.

To select reports based on Criteria:

Click the Reporting tab -> Criteria sub-tab in Criteria and Sorting.
The Field and Function combo box drop-down with buttons display.

The Criteria sub-tab contains the following fields and options.

Field	Click this combo box and select from the drop-down list the field you want to include in this report. You can only select one field at a time. The fields that appear in this picklist depend on the report you have selected in the Report Tree pane. For example, fields included in the Standard Time Zone report are different from those displayed for the Network Layout report. When you select a field, the Function combo boxes are activated.
Function	When you select a field in the Field combo box, the Function combo box is activated. Depending on the field specified, this section displays different fields and combo boxes. Several are listed below.
	Click this combo box and select either the “is” or “is not” function from the drop-down list. These are the only two arguments allowed for the field. The default is “is”.
	This Combo box allows you to select one of the operations from the drop-down list to complete this argument. The options are: ● Between: If you select a Field option like Event ID or Controller Type, this operator appears. Two variable fields appear below, where you supply a beginning and end range value. ● Equal to: The value selected from the Variable panel is identical to the values for this parameter you want reported from the Velocity database. If this value is selected, the Variable pane expands to include a search or picklist option of all possible values. ● Greater than: The value selected from the Variable panel is greater than values for this parameter you want reported from the Velocity database. If this value is specified, then an additional 'or equal to' field appears. ● Less than: The value selected from the Variable pane is less than the values for this parameter you want reported from the Velocity database. If this option is selected, the additional 'or equal to' field appears. ● Like: The value selected from the Variable pane is similar to the values for this parameter you want reported from the Velocity database. ● Starting with: Start with the value selected from the Variable pane and proceed forward using the Velocity database.
Search field Variable field	After you have selected an option in the 'Field' combo box and the required options in the 'Function' fields, one or more panes or combo boxes appear below the argument combo box. Click the search box to type as you begin typing, suggested results will appear below the search box, if one of the suggested results is the item you need, simply click on it to be taken to it directly. Click the variable field box to use the drop-down list to select the component directly. Depending on the size of the database there might be a delay in retrieving and populating this list.
Add	Button allows you to add the full argument to the list of report items needed for this customized report.
Edit	Button allows you to make changes to the existing Report criteria. Cancel button will activate when clicking the Edit button, you could click the cancel button if you decide to exit without saving the changes.
Update	Button allows you to save the changes made to the existing criteria and update.
Remove	Button allows you to remove the predefined report criteria.
Export type	Drop-down list allows you to generate your report in either PDF or MS Excel 97-2000 (Data Only) format.
Generate Report	Button allows you to download your report in the selected Export type format.

Reports based on Sorting

To select reports based on Sorting:

Click the Reporting tab -> Sorting sub-tab in Criteria and Sorting.
The Field and Direction combo box drop-down with buttons display.

The Sorting sub-tab contains the following fields and options.

Field

Click this combo box and select from the drop-down list one or more of those fields you want to sort for in this report. You can only select one field at a time. When you select a field, the possible values for that field appear in the Variable pane.

Fields change according to which report is selected; for example, fields included in the Standard Time Zone report are different from those displayed for the Network Layout report.

If you select a criterion in this combo box, the Function combo boxes are activated. When the All field is deselected, this field is activated.

Direction

Click this combo box and select either Ascending or Descending from the drop-down list. Ascending is the default.

If you select Ascending, all items detected in the Velocity database for the selected field will appear in the report listed from earliest/smallest/least significant to latest/largest/most significant.

If you select Descending, all items detected in the Velocity database for the selected field will appear in the report listed from latest/largest/most significant to earliest/smallest/least significant.

Add

Click this button to add the sort specification to the list of report items needed for this customized report. The new sort specification appears in the Selected Criteria List pane.