Column Properties

The column properties correspond with the properties of the respective object type, with some table-related restrictions.

Text and RTF text columns are special cases. A column property lets you switch between these two text variations later on. The property list also changes accordingly depending on this property.

Also see chapter "Common Object Properties".

Property

Description

Value

Description

Options
(only with some field types)

Opens the "Content" dialog for the relevant object type.

10-14_img45

Content dialog

Drilldown links

Opens the dialog for editing the drilldown links. A drilldown report can also be started from the preview.

10-14_img45

Drilldown dialog

Link URL

Link target (only effective for preview and PDF export).
Example: file://c:\users\public\x.log or URL

Link

Formula

 

Formula wizard

Save as JPEG

(only with pictures)

Print the image as a JPEG file if possible (not all file types support this option).

True

False

Formula

Yes

No

Formula wizard

Rotation

Rotates the object anticlockwise. For example, you can rotate the column title or barcode by 90° with this function.

0

1

2

3

Formula

0°

90°

180°

270°

Formula wizard

Format

Please consider that the formatting relates to the result of the entire expression. Use the Date$() and Fstr$() functions in the formula wizard if you only want to format part of the expression (e.g. with text and number within an expression).

True

False

Dialog

Bar width
(only with barcodes)

The narrowest bar width in SCM units (1/1000 mm). 0 = automatic adjustment. Not supported by all barcodes.

Formula

Formula wizard

 

Orientation

Orientation of the barcode within the object's frame

0

1

2

Formula

Left

Centered

Right
Formula

Bar color (only with barcodes)

Color of the barcode.

 

 

Bar width ratio (only with barcodes)

The relationship of the different widths of bars or spaces. Not supported by all barcodes.

Formula

Formula wizard

Show text
(only with barcodes)

This property lets you specify whether the content of the barcode is to be printed as text.

True

False

Formula

Yes

No

Formula wizard

Background

The background of the columns.

 

 

Text format

For presenting the text column differently.

True

False

Normal text

RTF Text

Sort Orders
(only header)

Sort orders (ascending+descending) for interactive switching in the preview.

Stacked sort orders can be defined via a dialog (requires application support), e.g. the data is first sorted by country, and then according to city/town.

Single-tiered sort orders can be selected via the list.

10-14_img47

 
 

10-14_img48

Dialog
 
 

 
List

Alignment

(pictures)

Describes how the image is to be arranged in the available area.

0

1
 

2

3

4

5

6

7

8

9

Centered

Next to each other (tiled)

Left top

Left bottom

Right top

Right bottom

Left

Right

Top

Bottom

Vert. Alignment

(barcodes)

Vertical alignment of the content in the available space.

0

1

2

Formula

Top

Centered

Bottom

Formula wizard

Alignment

(text)

Text alignment. Decimal means that numbers are aligned by their decimal points.

0

1

2

3

Formula

Left

Centered

Right

Decimal

Formula wizard

 

Decimal position

The position of the decimal point within the field, measured from the left edge of the previous frame.

Number

Formula

 

Formula wizard

Justified

Text is aligned to the right and the left (block text).

True

False

Formula

Yes

No

Formula wizard

Width

The width of the column. You will get an error message if the sum of the column widths exceeds the total width of the table object.

Number

Formula

 

Formula wizard

Fit

Specifies the behavior if the text is too long for one line.

To prevent long words from being truncated with value "1" (wrap), you can use the "Force wrap" option to ensure that a break occurs after the last suitable character. Value "3" (compress) reduces the character spacing and should only be used to a limited extent in order to guarantee legibility.

0

1

2

3

Formula

Truncate

Wrap

Shrink

Compress

Formula wizard

 

Widow/ Orphan control

Prevents widow and orphan lines.

The last line of a paragraph is referred to as a widow line if it is also the first line of a new column or page.

If a new page or column is triggered after the first line of a new paragraph, this line would appear alone at the end of the page or column. In this case, it is referred to as an orphan line.

True

False

Formula

Yes

No

Formula wizard

 

Force wrap

If a long word cannot be wrapped, a line break will be forced after the last suitable character.

True

False

Formula

Yes

No

Formula wizard

Height (not text or RTF text).

Fixed height of the field, the content is scaled (0: no fixed height). The highest column determines the overall height of a table row.

Number
Formula

 
Formula wizard

Fixed height (text or RTF text).

Fixed height of the field irrespective of the content. Excess text is discarded (0: no fixed height). The highest column determines the overall height of a table row.

Number
Formula

 
Formula wizard

Blank Optimization

Leading and double spaces are removed.

True

False

Formula

Yes

No

Formula wizard

Line spacing (only with text)

Spacing between the text lines.

Number
Formula

 
Formula wizard

Frame

Specifies the frame characteristics and margins for the individual table cells. Together with the selected font, the "top" and "bottom" cell margins determine the height of the table rows.

10-14_img21

Number

Formula

Dialog

 
 
Formula wizard