Configure Column Rules

Managing Reports Using the Report Builder › Data Views › Configure Column Rules

Configure Column Rules

You can use column rules to configure the presentation of a data view that appears as columns in a report.

Follow these steps:

Click Administration, Report Builder.
The Report Builder page appears, with Data Objects selected in the left menu under the main menu.
Click Data Views in the left menu.
The list of existing data view folders appears.
Expand the folders to display the data view you want. Click the Edit (pencil) icon.
The data view opens for editing.
Click the Column Rules button.
The Create Column Rules dialog appears.
Select the column you want in the Settings for Column field.
The settings appear for the selected column.
Complete the fields and configure the settings on each tab. For each tab, do the following, as needed:
- Select Show Help to display help text for the tab.
- Click Advanced to specify advanced settings.
- Review the guidelines for completing the fields on the tabs.
Click OK.
The Catalog system saves the column rule.

You have set up the column rule.

Column Rule Tabs

When you configure column rules while adding a data view, you optionally configure the specifications on each tab of the Column Rules dialog. Each tab contains one or more fields. For each tab, this topic explains the fields that require explanation.

Linking Tab

The following fields on this tab require explanation:

Link Items in Column column-name To Other Pages

Specifies whether to link the values in the column to another web page, either within or outside CA Service Catalog.

Select this field to activate it and to open the fields under it for editing.

When a user clicks a value in this column in a report, this link activates, and the linked item appears. Options follow:

Special

Specifies a link within CA Service Catalog to another data view, a report layout, or a GUI node.

Link Address

Specifies one of the following:

Another data view, a report layout, or a GUI node, if you used the Special link to add one.
A URL to a website or file share, if you did not use the Special field. Enter the URL manually.

Also, the Link Address field optionally specifies a variable from the data object on which the data view is based. Click the Insert Variables icon to add a variable to this field.

Formulas Tab

The following fields on this tab require explanation:

Apply Formula to Column column-name

Specifies whether to apply a JavaScript formula to the column value.

Select this field to activate it and to open the fields under it for editing.

Special

Specifies an image formula to apply on the data for the column. Use the formula to format a cell or row based on a value. Use the following format:

IMG:image_file_path

image_file_path specifies the folder and file name under the USM_HOME\view\webapps\usm folder.

For example, the following line displays the add.gif image in the cell for the column:

IMG:images/add.gif

To include the cell text also, enter the column name variable within the single quotes. An example follows:

IMG:images/add.gif]%Col1%

Note: If you use multiple Catalog Component servers, verify that this file resides in the same folder location on all servers.

Column Formula

Specifies variable from the data object to use in the column formula. To use a variable, click the Insert Variables icon.

Examples of formulas using JavaScript follow:

100*%name%

Math.max(%Col1%,%Col2%)

(10*%Col1%)+(20/%Col2%))+' Units'

%name%’.toUpperCase()

Translations Tab

The following fields on this tab require explanation:

Apply Translations to Column column-name

Specifies whether to apply a translation formula to the column value.

Select this field to activate it and to open the fields under it for editing.

Translations

Substitutes a translated value for each data object value. You can optionally apply the translation before applying a formula to the column value.

For example, a column can return data as integer value 1 which means opened, and 2 which means closed. You can apply translations that do the following:

Display Opened in place of all values of type 1 in a column
Display Closed in place of all values of type 2

Formatting Tab

The following fields on this tab require explanation:

Apply Formatting Settings to Column column-name

Applies formatting to a column. Examples include font, justification, highlighting, and color.

Select this field to activate it and to open the fields under it for editing.

Summary Tab

The following fields on this tab require explanation:

Summary

Adds summary information for the column.

Select this field to activate it and to open the fields under it so that you can select them. The fields you select appear in the summary of the report.