Formatting Column Contents

The default appearance of column contents in results is based on cascading style
sheets and XML message files. You can use the Style tab of the Column Properties dialog
box to override several default settings, such as the font and font size to use, and
copy and paste formatting.

If you are overriding the default formatting properties for a column, your selections are
static. If you are specifying conditional formatting properties for a column, your selections
apply only if the condition is met.

note: The selections for horizontal and vertical alignment are similar to text justification
selections in word processors. Vertical alignment does not have any impact unless
the column spans multiple rows of other columns.

How to …

Format Column Content

1. Click the  button for the column, and choose Column Properties from the dropdown
menu. The Column Properties dialog appears.

The Column Properties dialog appears.

Column Properties Dialog

2. Click the Style tab.

3. In the Font section, make your selections for font family, size, color, style (such as
bold), and any effects to apply (such as underlining).

4. In the Cell section, make your selections for alignment.

• For horizontal alignment, choose one of the options described in the following
table

• For vertical alignment, choose one of the options described in the following
table.

5. In the Cell section, make your selection for an image to display inside the cell by
clicking the Image button.

The Graphics dialog appears.

Graphics Dialog

• If you do not want to include an image, click the No Image option.
• To include a custom image, click the Custom Image option and specify the
appropriate path in the text box.
• The image should be one that is accessible to all users who will view the results.
Custom images can be used for both conditional and unconditional results.
• To include an image distributed with Xactly Analytics, use the graphics selection
window and make your selection by clicking the radio button next to the
image.
• The window shows images that are useful in conditional formatting, such as
meters and trend arrows. The left pane shows the categories of images. When
you click on an image category, the right pane shows the images in that category.
• To specify the location of the image within the cell, use the Image Placement
drop-down list and select one of the options described in the following table.

6. In the Cell section, make your selection for a background color for the cell.

7. In the Border section, make your selections for the border position, color, and style
of the cell.

8. To override style and class elements specified in style sheets, make your selections
in the Advanced Style Options (CSS) section:

a. Click the settings you want to use.
b. Provide the location of the class, style, or style sheet.

9. Click the Data Format tab to control the way data is displayed.

You have the following options:

• Override Default Data Format. This option allows you to override the default
display characteristics. The selections that you see vary based on the data
type. For example, if the column contains numeric data, you can choose how
you want the numbers treated, such as percentages, month names, or dates.

You can choose the number of decimal places to display, how to display negative
numbers, the number of digits to show, and the thousands separator to
use. If your column contains text, you can choose how to treat the text, such
as plain text, HTML, or a link.

• If you are editing a date column, you can select Override Default Data Format
and either choose a pre-defined format from the Date Format drop-down list,
or choose Custom from the Date Format drop-down list and then specify a
custom date format (in the corresponding field).
• If you are editing a timezone column, the Data Format tab displays the Display
Time Zone drop-down list where you can select and apply a specific time zone
to the column. Note the following options:
• If you select the Default time zone option from the list and the administrator
has specified a system default time zone, the system default time zone
will be used to display the time value in the column.
• If you select the Default time zone option from the list and the administrator
has not specified a system default time zone, the user’s preferred time
zone will be used to display the time value in the column.
• If you select the Data time zone option from the list, the original data
retrieved from the database will be displayed.
• If you select a specific time zone (for example, GMT +05:45 Kathmandu),
that time zone is used to display the time value in the column.

10. Click the OK button.