This section explains the customization options that are available for interactive reports. The major customization tasks that you can perform are:
To customize a report, select the report in the left navigation pane or open the report, then click the Edit icon. The report opens in edit mode. Note that when you are creating a new report, the same customization options are available to you.
Note To be able to save a customized report, you must select the report and click Edit. While you can perform some customization by not being in edit mode, you will not be able to save the changes after you are done. After completing the customization, we recommend that you save the report using the Save As functionality. Saving the report as is changes the name of the report to a default file name (without the file name extension).
provides a snapshot view of customization options available.
Figure 5-1 Customizing Options
Table 5-1 Customizing Reports—Icons Description
Contains all the fields that can used in the report selected.
Allows you to customize the report by applying formatting options such as font type, size, color, background color. For more information, see Changing the Font Style.
Allows you to change report template and orientation. For more information, see Changing the Report Template and Changing the Size and the Orientation of a Reports.
Query Settings icon
Allows you enable options such as auto-refresh, maximum row in a report. For more information, see Additional Useful Customization Options.
Allows you to export your report to be saved at an external location.
Allows you to create basic and advanced filters. For more information, see Adding a Filter.
Allows you to view the layout of the report. This is useful when you need to view and rearrange groups.
Allows you to apply a quick, simple filter to the report. For more information, see Applying Quick Filters.
Grouping Data in Reports
You can group the data in your report by one or more fields. For example, you could group your data by device type, severity, or location. From the following example (), the group names are placed in the following order: Device Name, Configured Service, and Configured Service Name.
The Device Name contains a groups of Configured Services, which in turn contain groups of entries for Configured Service Names. The list of devices is arranged in ascending order and each device data is reported serially.
Figure 5-2 Grouping Report Data—Example
Follow the procedure below:
Step 1 Click the Layout icon.
A field to add groups and the available columns in the report appear.
Step 2 Drag and drop the fields to the Groups field. The report immediately rearranges based on the grouping specified.
If you need to group the data in your report by more than one field, drag and drop the required fields. If more than one field is present, the groups are arranged in sets. The first field in the group is the super set of the second field.
Step 3 To delete the group name, click the name of the group from the Groups field, and drag and drop in the recycle bin that appears. When you delete a group, the related column is deleted also from the table.
Changing the Data Presentation in Reports
This section describes the procedure to adjust and reorder the columns in your report.
To reorder your column, select the column you want to move and drag it to your desired location. Alternatively, select the column you want to move, click the down-arrow and select Move (Right or Left) from the menu.
To adjust your column width, select the column, then click on the vertical line that divides your column headers. A small arrow appears. Move the arrow left or right to adjust your column width.
Sorting Data in Reports
Step 1 To sort the data available in your report, click the small down-arrow icon next to the column name.
Note If the down arrow is not available, you must enable the menu options from General tab > Preferences > Enable Menu Buttons.
Step 2 Click Sort > Ascending/Descending.
Formatting Interactive Reports
You can specify how your reports are formatted and presented. The following topics help you perform the task.
Changing the Report Template
Step 1 From the left navigation pane, choose General tab.
Step 2 Browse through the available templates using the left and right arrows. Select the template of your preference and confirm. The template Left Indented - Jade contains the product name, Cisco Prime Network Operations Reports, on the header.
Step 3 Click Select.
The Select dialog box with all the available options of templates appears. Choose the template. The template is applied to the report.
Changing the Size and the Orientation of a Reports
Step 1 From the left navigation pane, choose General > Page Setup.
The Page Setup dialog box appears.
Step 2 Choose the correct page format and orientation for your report from the list. The page margin measurements are available in the lower portion of the dialog box. You can adjust the measurements as needed. We recommend that you choose the landscape option if the number of fields in your report are many.
Step 3 Click OK to save the changes.
Changing the Font Style
After you generate a report, you can change the font, the color, and the font size of the report contents. You can later copy and paste the formatting from one column to another column within the same report. On an interactive report, from the left navigation pane, choose Formatting.
Step 1 On an interactive report, select the column for which you want the formatting to be applied. To select multiple columns, select the columns with the Ctrl key pressed.
Step 2 From the left navigation pane, select Formatting. Set the formatting specification for the table. The formatting is instantly applied.
To copy the format from one column to another:
Step 1 Select the column from which the format is to be copied.
Step 2 Click the Copy icon.
Step 3 Choose the column on to which the formatting has to be applied.
Step 4 Click the Paste icon.
The formatting is applied.
Filtering Interactive Reports
Some reports are very long, and may run into several pages. However, not all details represented in the report may interest you. You can filter the report to specifically view the information that you need.
Adding a Filter
After you generate a report, you can filter the contents of the report based on the columns present in the report. To create a filter:
Step 1 Click the Filter icon.
The filter pane opens.
Step 2 From the left navigation pane, from the Data tab, drag and drop the fields (that are already available in the report as columns) to the Apply Filter pane.
The Filter on Field Name appears.
Step 3 From the Filter on Field Name, specify the condition based on which the filter has to be applied. Enter a parameter name that describes the filter name.
To narrow down the filter parameters, and to specify your exact requirement, choose the Select from a List option. For example, if you want to filter the report for a few types of devices, drag the Device Type field, and from the Select from List option, choose the types of devices to be included, and move them to the Currently (Included) pane. The filter is now applied only on the device types specified.
Step 4 Click OK.
Creating Advanced Filters
After you create filters using the steps explained in Adding a Filter, you can customize the filter to exclude and include data in the combination that you set. For example (), from the Virtual Machine State Inventory report, you can set the filter to view report details of one of the following fields: Host Name (with specific name), RAM Size (that you can specify), Host Up Time (specify a period). You can also give an ‘AND’, ‘OR’ operator with a few more conditions that must be filtered with the above-mentioned conditions.
Figure 5-3 Filtering Reports—Example
Perform the following steps to customize the filter for advanced settings:
Step 1 Create a filter as outlined in the section Adding a Filter.
Step 2 From the fields that are listed in the filters pane, create advanced filters by creating a hierarchy. From the down arrow displayed on the filter parameter, choose the position of the parameter. Click Move Up or Move Down, as required.
Step 3 If you prefer a parameter to be an AND operator of another parameter, click the down arrow of the first parameter and choose Indent.
For example, if you want to view report details of Host Name of a specific RAM Size, move the Host Name up, and indent RAM Size. If you desire to view the details of a host with Host Name and Host Up time parameters, move Host Name up and indent Host Connection State.
Step 4 Repeat the procedure for the filters you have chosen.
Step 5 From the master AND, OR operator, choose as required.
For example, if you desire to filter based on both (Host DNS Name and RAM Size) and (Host Name and Host Connection State), choose the AND operator from the drop-down list on its right.
Applying Quick Filters
Prompts are quick filters that are used without adding specific restrictions. You can filter the data based on any data field available on the left navigation pane. However, you cannot specify ‘And’/’Or’ options.
To create a prompt, click the Prompts icon, and drag and drop the fields from the left navigation pane.
For example, if you set the prompt for VM Device State and Number of Devices, you can see the number of devices for a specific VM device state. Prompts are especially useful when you want to add a From and To date before you begin generating customizable prepackaged fault reports.
Note To add a prompt for a range of days (with From and To dates options), drag the Date field twice. This creates two options from which you can select the From and To date.
Upon adding prompts, the report is filtered to reflect the prompts, and a refreshed report appears. If you select the prompt for VM Device State (with the state Suspended selected), the devices whose VM device state is suspended appears.
The structure added in Prompts reflects in the Filter option as well.
You can edit the prompts that you have created for reports. Editing the prompts functionality allows you to choose the methods of selecting prompt options such as radio buttons, check box, or text box. You can also specify the first value that needs to be selected by default. To edit a prompt, follow the procedure below:
Step 1 Select a Prompts. From the data tab, choose the required parameters and drag and drop to the Prompts field.
Step 2 After the data field is added, mouse over on the prompt. A pencil icon appears. Click the pencil icon.
The Prompt for data field window appears.
Step 3 Enter a name for the prompt.
Step 4 Choose a Type of Control; this decides the modality of selection of items in the prompts.
If you choose the control type List, you can specify the number of values that are displayed when you begin choosing the items listed in the Prompts field.
Step 5 Choose a Data Type. The following options are available:
- Metadata List—Select this data to enable the prompts feature to work against a database. If you choose Metadata List, select the Data Source that the report runs against.
- Static List—This option is not supported in Prime Network 4.2.2 Operations Reports.
Step 6 From the Control Properties pane, choose the options as required:
- Initially Selected—This allows you to specify the value that is selected from the list by default
– Use First Value—By default, selects the first value from the available list
– Specify—Specify the value that should be selected by default when you click Prompt.
Step 7 Click OK.