...
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.
...
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:
...
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. |