Properties of Table in Page Report
A table can have the following child objects: Table Header, Table Group, Table Footer, Table Column and Table Cell.
The properties of a table object in a page report are as follows:
Property Name | Description |
---|---|
General | |
Class Type | Indicates the class type of the object. This property is read only. |
Data Inherit | Indicates whether the dataset for this object is inherited from another object. This property is read only. |
Dataset | Indicates the dataset used by the object. This property is read only. |
Instance Name | Shows the instance name of the object. This property is read only. |
Geometry | |
Height | Specifies the height of the object. Enter a numeric value to change the height.
Data type: Float |
Width | Specifies the width of the object. Enter a numeric value to change the width.
Data type: Float |
X | Specifies the horizontal coordinate of the top left corner of the object, relative to its parent container. This property is ignored if the Position property is set to static. Enter a numeric value to change the position.
Data type: Float |
Y | Specifies the vertical coordinate of the top left corner of the object, relative to its parent container. This property is ignored if the Position property is set to static. Enter a numeric value to change the position.
Data type: Float |
Color | |
Background | Specifies the background color of the object. Choose a color from the drop-down list or select Custom to customize a color. You can also use a formula or edit an expression that returns a color, or enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.
Data type: String |
CSS | |
Class | Specifies a CSS class to be applied to the object which is a valid class in the CSS file.
Data type: String |
Style | The property can be used in two ways.
Data type: String |
Others | |
Auto Expands | Specifies whether the objects in cells of the table will expand to their empty neighbouring cells horizontally when the actual size of the objects is bigger than the cells due to no enough column or page width for auto fit. This property requires that the property Auto Fit for the objects in the table cells is set to true.
Data type: Boolean Note: The property does not apply to horizontal tables. |
Cache | Specifies whether to cache the dataset for this object in the data buffer so other objects which use the same dataset can share the data rather than perform their own SQL query.
Data type: Boolean |
Default for Filter | Specifies whether to show the data component as the default component in the Apply to drop-down list of the Filter dialog in Page Report Studio.
Data type: Boolean Note: In a page report tab, only one data component’s Default for Filter property can be set to true. |
Export to Applet | Specifies whether to include the object when exporting the report to Applet.
Data type: Boolean |
Export to CSV | Specifies whether to include the object when exporting the report to CSV.
Data type: Boolean |
Export to Excel | Specifies whether to include the object when exporting the report to Excel.
Data type: Boolean |
Export to HTML | Specifies whether to include the object when exporting the report to HTML.
Data type: Boolean |
Export to PDF | Specifies whether to include the object when exporting the report to PDF.
Data type: Boolean |
Export to PostScript | Specifies whether to include the object when exporting the report to PostScript.
Data type: Boolean |
Export to Report Result | Specifies whether to include the object when exporting the report to Report Result.
Data type: Boolean |
Export to RTF | Specifies whether to include the object when exporting the report to RTF.
Data type: Boolean |
Export to Text | Specifies whether to include the object when exporting the report to Text.
Data type: Boolean |
Export to XML | Specifies whether to include the object when exporting the report to XML.
Data type: Boolean |
Horizontal | Specifies whether to show the table in horizontal style.
Data type: Boolean |
Invisible | Specifies whether to show the object in the design area and in the report results. All formulas and calculations will still be performed if the property is set to true.
Data type: Boolean |
Invisible for Filter Dialogs | Specifies whether to show the data component in the Apply to drop-down list of the Filter dialog in Page Report Studio. This property cannot be edited when Default for Filter is set to true.
Data type: Boolean |
Position | Specifies the position of the object. Choose an option from the drop-down list.
Data type: Enumeration |
Record Location | Specifies the calculation point for the properties which use formulas. Choose an option from the drop-down list.
Data type: Enumeration |
Split Overflow Columns | Specifies whether to display the overflow columns of the table on subsequent pages. The table object containing overflow columns on subsequent pages inherits the same Y value in its container, so that it keeps the same number of records as the table in the original page. However, its X value is reset to 0 for both static and absolute positions so as to show as many columns as possible. The height of each table row for overflow columns is the same as the corresponding row height in the original page.
Data type: Boolean |
Suppress | Specifies whether to show the object in the design area and in the report results. All formulas and calculations will be skipped if the property is set to true.
Data type: Boolean Note: When both the Invisible and Suppress properties of an object are set to true, Suppress has the higher priority. |
Suppress When Empty | Specifies whether to display the object in the report results when no record is returned to it.
Data type: Boolean |
Suppress When No Records | Specifies whether to display the object in the report results when no record is returned to its parent data component.
Data type: Boolean |
Border | |
Border Color | Specifies the color of the border of the object. Choose a color from the drop-down list or select Custom to customize a color. You can also use a formula or edit an expression that returns a color, or enter a hexadecimal RGB value (for example, 0xff0000) to specify a color.
Data type: String |
Border Thickness | Specifies the width of the border. Enter a numeric value to change the thickness.
Data type: Float |
Bottom Line | Specifies the line style of the bottom border of the object. Choose a style from the drop-down list.
Data type: Enumeration |
Left Line | Specifies the line style of the left border of the object. Choose a style from the drop-down list.
Data type: Enumeration |
Right Line | Specifies the line style of the right border of the object. Choose a style from the drop-down list.
Data type: Enumeration |
Top Line | Specifies the line style of the top border of the object. Choose a style from the drop-down list.
Data type: Enumeration |
TOC | |
Anchor Display Value | Specifies a string or formula to display for the TOC entry for this object in the TOC Browser. By default it is the value of the specified object. The TOC Anchor property must be set to true for this property to take effect.
Data type: String |
TOC Anchor | Specifies whether to include the object in the TOC Browser for the report.
Data type: Boolean |
Accessibility | |
External CSS Class Selector | Specifies a class selector to be applied to the object when exported as HTML. Enter a valid class name from the CSS file.
Data type: String |
External ID | It is mapped to the HTML attribute id. This attribute specifies a name to the object, which must be unique in the report.
Data type: String |
External Style | It is mapped to the HTML attribute style. This attribute specifies style information for the object.
Data type: String |
Summary | It is mapped to the HTML attribute summary. This attribute provides a summary of the object's purpose and structure.
Data type: String |