The properties of a table in a page report are:
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, in inches or centimeters. Enter a numeric value to change the height.
Data type: Float |
|||
Width | Specifies the width of the object, in inches or centimeters. 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 in inches or centimeters.
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 in inches or centimeters.
Data type: Float |
|||
Color | ||||
Background | Specifies the background color of the object. Choose a color from the drop-down list, enter a hexadecimal RGB value (e.g. 0xff0000), choose a formula that returns a color, or select Custom from the drop-down list to specify the 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 |
|||
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 Page Report Result | Specifies whether to include the object when exporting the report to Page Report Result.
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 |
|||
Position | Specifies the position of the object. Choose an option from the drop-down list.
Data type: Enumeration Note: This property only affects objects with a parent container that is the report body, a tabular cell, or a text box. |
|||
Record Location | Specifies the calculation point for the properties which use formulas. Choose an option from the drop-down list.
Data type: Enumeration |
|||
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 container.
Data type: Boolean |
|||
Border | ||||
Border Color | Specifies the color of the border of the object. Choose a color from the drop-down list, enter a hexadecimal RGB value (0xCCAA00), choose a formula that returns a color, or select Custom from the drop-down list to specify the color.
Data type: String |
|||
Border Thickness | Specifies the width of the border in inches or centimeters. 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 |
The following topics list properties of the children of a table: