Format (Reporting)
Click here to see this page in full context


Format

The settings in this page apply only to the detail cells of the table.

Cell height can increase/decrease to accommodate contents

If you select this option, the height of the cells is adjusted automatically so that long texts can be shown with line breaks. This option is especially useful if the text field contains an expression.

Column Width

This option will be displayed for string (text) and numeric data type. It is useful to define a column width (that is the number of characters) applicable to the cell.

Horizontal Alignment

Horizontal alignment of the text inside the cells.

Vertical Alignment

Vertical alignment of the text inside the cells.

Padding

Margin between the text and the border of the cells.

Number Format

The Number Format options are only shown if the value is a number or a date.

With Number Format, you can choose the way in which numbers are shown, for example, as a decimal number, date, or currency. Depending on the category selected in the drop-down list at left, you can choose between different styles in the drop-down list at right.

Detail Row

If a table has two detail rows with numbers, you can choose the row for which you want to set the format.

Rounding

Define the precision of a number, currency, or percentage.

  • Decimal Places

    The number is shown with the given amount of decimal places.

  • Significant Digits

    The number is masked with zeros, only the specified number of significant digits is shown.

    For example, if you set the significant digits to 2, the numbers are shown as follows:

    1234 as 1200

    1 as 1.00

    0.1234 as 0.12

    0.1 as 0.10

    0.01234 as 0.012

Show GMT offset

Select the check box to add information on the time zone to all date fields.

Times are always shown as local times. The time offset includes the daylight saving time. For example, an injection acquisition date would look as follows:

  • Injection acquired in June (summer time):

    • in London as 06/30/2015 10:30:00 AM (GMT + 1:00)

    • in Berlin as 06/30/2015 11:30:00 AM (GMT + 2:00)

  • Injection acquired in January (winter time):

    • in London as 01/31/2015 09:30:00 AM (GMT + 0:00)

    • in Berlin as 01/31/2015 10:30:00 AM (GMT + 1:00)

Preview

The Preview area shows the appearance of the currently selected settings.