Table Cell

The Table Cell control represents an individual cell within a table.

In general, the Table Cell control's properties are similar to the properties of the Label control.

In the Property Grid, the Table Cell control's properties are divided into the following groups:

Appearance

• Background Color – Specifies the background colour for the controls contained within the band. This option is also available on the Formatting Toolbar ().

• Border Color, Border Dash Style, Border Width and Borders – Specifies border settings for the control.

• Font – Specifies the font settings for the controls contained within the band. Some of these settings are available on the Formatting Toolbar.

• Foreground Color – Specifies the text colour for the controls contained within the band. This option is also available on the Formatting Toolbar ().

Formatting Rules – Displays the Formatting Rules Editor which enables you to choose which rules should be applied to the band during report generation, and define the precedence of the applied rules. For further information, refer to Conditionally Change a Control's Appearance.

• Padding – Specifies indent values used to render the contents of the controls.

• Style Priority – Defines the priority of various styles (for example, background colour or border colour). For further information on style inheritance, refer to Styles Concepts.

• Styles – Defines odd and even styles for the controls, as well as assigning an existing style to the them (or a newly created one). For further information on style inheritance, refer to Styles Concepts.

• Text Alignment – Used to change the alignment of the control's text. This option is also available on the Formatting Toolbar.

Behavior

• Angle – Specifies the text rotation angle. The measurement unit is a degree, and the orientation is counterclockwise. As standard HTML does not support text orientation, the property is ignored when a report is displayed within a web page.

• Can Grow – If the check box is selected, the label height is automatically increased, if required, to fit the text. If there are other controls below the current label, they are moved down to prevent them from overlapping. Note that if a control overlaps the grown label, it is not moved down by the expanded label.

• Can Shrink – If the check box is selected, and the text does not completely fill a label, the label height is decreased to the height of the text. If there are other controls below the current label, they are moved up to fill the gap. Note that if a control overlaps the shrunk label, it is not moved up under the shrunk label..

• Keep Together – Specifies whether the contents of the band can be horizontally split across pages. Reporting attempts to keep band entries on a single page. In general, if the contents are too large to fit on a single page, then the band is started on a new page, and continues on the following page.

  If it does not fit on the next page either, then the Table Cell will be split despite this property's setting.

• Multiline – If the check box is selected, a label processes newline characters found in the text to start a new line. For example, when editing the label text, a new line can be inserted by pressing ENTER, and in this case, the Multiline check box is automatically selected.

• Process Duplicates – Determines the behaviour of the control when the data source contains consecutive repeating records. The records can be processed as is (when the property is set to Leave), suppressed except for the first entry (Suppress) and suppressed with a blank space printed instead of the repeated records (Suppress and Shrink).

• Process Null Values – Determines whether to process Null (blank) values if they appear in the control data source. Null values can be processed as is (when the property is set to Leave), suppressed (Suppress) and suppressed with a blank space printed instead of the blank records (Suppress and Shrink).

• Scripts – Contains events which can be handled with scripts. For more information on scripting, refer to Handle Events via Scripts.

• Visible – Specifies whether the band is visible when using the print preview.

• Word Wrap – If the check box is selected, text entered into the multiline control is wrapped to the next line if it does not fit in the control or is interrupted by a newline character. If the check box is not selected, text entered into the multiline control is displayed on the same line except when forced onto a new line by a newline character.

Data

• (Data Bindings) – If the current report is bound to data, this property is used to bind some of a Table Cell’s properties (Bookmark, Navigation URL, Tag and Text) to a data field obtained from the report's data source, and to apply a format string to it. For further information, refer to Display Values from a Database (Bind Report Elements to Data).

• Lines – Provides access to the Text property of a Table Cell in the Multiline mode.

• Null Value Text – Specifies the displayed label text when the value of the bound data field is null.

Summary – Performs calculations (for example, summary, max, min or average) on a data field.

Note: Summarization is possible for a single data column only. To perform calculations with several data fields, use calculated fields.

For further information on calculating summaries, refer to Add Totals to a Report or Group.

• Tag – Adds additional information to a control; for example, the Id, by which the control can then be accessed via scripts.

  If the current report has a data source, the Tag property can be bound to a data field obtained from the data source. To do this, expand the (Data Bindings) property and from the Tag.Binding dropdown list, select the required data field.

Text – Defines a line of static text to be displayed. To type several lines of text, select the Multiline property on the Behavior tab.

When a label is selected, entered text is automatically added to the control.

If the current report has a data source, the Text property can be bound to a data field obtained from the data source. To do this, expand the (Data Bindings) property and from the Text > Binding drop-down list, select the required data field.

Note: When a Table Cell is selected in the designer, you may start typing the text, and it will be automatically entered into the in-place editor.

• Xlsx Format String – Specifies the Excel format for the control when exported to an Excel file.

Design

• (Name) – Determines a control's name, by which it can be accessed in the Report Explorer, the Property Grid and via scripts.

Layout

• Snap Line Margin – Specifies the margins for the control, which are maintained when the control is aligned using snap lines.

• Width – Specifies the control's width, in report measurement units.

Navigation

Bookmark and Parent Bookmark – These properties are used to create a hierarchical structure within a report called a document map.

If the current report has a data source, the Bookmark property can be bound to a data field obtained from the data source. To do this, expand the (Data Bindings) property and from the Bookmark.Binding dropdown list, select the required data field.

For further information, refer to Add Bookmarks.

Navigation URL and Navigation Target – Use the Navigation URL property to specify a URL for web browser navigation when a user clicks the control. The web browser displays a page in a window or a frame as specified by the Navigation Target property.

Note: A URL should have an appropriate prefix (for example, 'http://'). Cross references can be created within the report by assigning the name of the target control to the Navigation URL property, and setting the Navigation Target property to _self. For further information, refer to Create Hyperlinks.

If the current report has a data source, the Navigation URL property can be bound to a data field obtained from the data source. To do this, expand the (Data Bindings) property and from the Navigation URL.Binding dropdown menu, select the required data field.