Report Editor - Table : Columns Editor Dialog Help

This dialog allows:

• to add or remove columns.
• to define cell values, their formatting and style properties.

It consists of five sections.

The main section, represents a preview of the table layout.

In this section you can add or remove columns, using “+” and “-” buttons.

It is possible to change widths and heights of rows and columns dragging borders.

If a table has a header and/or a footer, it will take the first or the last row respectively.

Active cell has selection rectangle. Actions in other sections are applied to active cell only.

“Edit…” button invokes Expression Editor dialog to set value for the active cell.

Every cell has a contextual menu:

This section contains a few flags:

• Can Grow – If ON, then vertical growing of cell (and the whole row) will be performed to fit contents.
• Transparent – If ON, then the background of the cell will be transparent.
• Wrap – If ON, then the contents of the cell will be wrapped.

A value can be one of two types – Expression or Summary, switch between them is performed using the property Kind.

With an Expression kind cell acts like an "Expression Field". Expression should be written to the Value property. It can hold macros, SQL expressions, static text - everything, allowed for ordinary expression field.

Summary option allows to add a summary to the table. It works like an ordinary "Summary" control.

Editing button invokes either expression or summary editing dialog, depending on the selected kind.

Format property allows to apply desired format to the cell content. Some formats allow to define custom pattern, in that case Pattern property is used. Formatting works the same way, like for ordinary Field controls.

Print If property allows to show or hide value of cell depending on entered expression.

This section allows to define set of styling properties of an active cell:

• Alignment – Vertical and horizontal alignment of the cell content.
• Background – Background color of the cell.
• Font – Font used for rendering the cell contents.
• Foreground – Foreground color of the cell.
• Conditional – Allows to set different cell's styles depending on some conditions.

Edit… button of Conditional property shows usual Conditional Style dialog.

Conditional style, for example, can be used to create zebra-style grid.