BackPrevious Topic  Next TopicNext

Table Properties

This topic describes the properties of a Table object.

Designer provides some properties only when you use the object in certain report types. You can get details from the Available For column in the property table.

Property Name Available For Description
General
Class Type Query Page Report Shows the class type of the object. This property is read only.
Data Inherit Query Page Report Shows whether the object inherits dataset from another object. This property is read only.
Dataset Query Page Report Shows the dataset the object applies. This property is read only.
Instance Name Query Page Report Shows the instance name of the object. This property is read only.
Geometry
Height Page Report, Web Report, Library Component Specifies the height of the object. Type a numeric value to change the height.

Data type: Float

Width Page Report, Web Report, Library Component Specifies the width of the object. Type a numeric value to change the width.

Data type: Float

X Page Report, Web Report, Library Component Specifies the horizontal coordinate of the top left corner of the object, relative to its parent container. Designer ignores this property if the object's Position is "static". Type a numeric value to change the position.

Data type: Float
Y Page Report, Web Report, Library Component Specifies the vertical coordinate of the top left corner of the object, relative to its parent container. Designer ignores this property if the object's Position is "static". Type a numeric value to change the position.

Data type: Float
Color
Background Page Report, Web Report, Library Component Specifies the background color of the object. Choose a color from the drop-down list or select Custom to customize a color in the Pick a Color dialog box, or type a hexadecimal RGB value (for example, 0xff0000) to specify a color. For a page report, you can also use a formula or edit an expression to return a color.

Data type: String
Alternating Line Color
Include Header and Footer Page Report, Web Report, Library Component Specifies whether to apply the alternating color to the footer, group headers, and group footers of the table. The default behavior (the property being "true") is to apply the alternating color to all the table rows except the table header. If you set the property to "false", the alternating color applies to the table detail rows only.

Data type: Boolean
Pattern List Page Report, Web Report, Library Component Specifies the patterns for the alternating color you want to apply to the table rows. Select the ellipsis Ellipsis button in the value cell to specify the color patterns in the Color List dialog box.

Data type: String
Show Page Report, Web Report, Library Component Specifies whether to use alternating color for the table rows. Alternating color works as the background color and overwrites the table rows' own background color.

Data type: Boolean

Note icon To apply the alternating color to merged cells in group tables, you also need to set the background color of the merged cells to that of the alternating color.
CSS
Class Page Report, Web Report, Library Component Specifies the name of the Class Selector to apply to the object, which you define in the CSS file of the style the report applies.

For example, if you define the CSS file as follows:

@charset "GBK";
TextField {Background: #ff0000}
/*Style=LabelX*/
TextField[Style="LabelX"]{Background: #0000FF}
/*ID=W*/
TextField#W{Background: #FFFF00}
/*class=C*/
TextField.C{Background: #00FFFF}

To apply the Class Selector in the file to the object, type C in the value cell.

Data type: String
Style Page Report, Web Report, Library Component Specifies the style you want to apply to the object. You can specify the style in two ways:
  • Type the style which should be an Attribute Selector whose attribute is "style" in the CSS file of the style the report applies. For example, to apply the style in the above sample CSS file to the object, type LabelX in the value cell.
  • Choose a style from the drop-down list if you have specified the Style Group property for the report tab or web report, and there are styles in the style group that are applicable to the object.

Data type: String
Others
Auto Expands Page Report, Web Report, Library Component Specifies whether to expand the objects in cells of the table to their empty neighboring 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 Auto Fit property for the objects in the table cells is "true".

Data type: Boolean

Note icon This property does not apply to horizontal tables.
Auto Scale in Number Page Report, Web Report, Library Component Specifies whether to automatically scale the Number values in the object that fall into the two ranges:
  • When 1000 <= value < 10^15, Designer applies the following quantity unit symbols of the International System of Units to scale the values: K (10^3), M (10^6), G (10^9), and T (10^12).
  • When 0 < value < 0.001 or value >= 10^15, Designer uses scientific notation to scale the values.

Data type: Boolean
Cache Query Page Report Specifies whether to cache the dataset for this object in the data buffer, so that other objects using the same dataset can share the data rather than perform their own SQL query.

Data type: Boolean
Default for Filter Page Report, Web Report Specifies whether to display the object as the default data component in the Apply To drop-down list of the Filter dialog box at runtime.

Data type: Boolean

Note icon In the same report, you can only set one data component's Default for Filter property to "true".
Enable Navigation Web Report Specifies whether to display a page navigation bar for the table right below it at runtime, if the table contains more than one page. When you set this property to "true", you can further specify the height and width of the page for the table to display multiple pages via Navigation Height and Navigation Width.

Data type: Boolean

Export to CSV Page Report, Web Report, Library Component Specifies whether to include the object in the CSV output of the report.

Data type: Boolean
Export to Excel Page Report, Web Report, Library Component Specifies whether to include the object in the Excel output of the report.

Data type: Boolean
Export to HTML Page Report, Web Report, Library Component Specifies whether to include the object in the HTML output of the report.

Data type: Boolean
Export to PDF Page Report, Web Report, Library Component Specifies whether to include the object in the PDF output of the report.

Data type: Boolean
Export to PostScript Page Report, Web Report, Library Component Specifies whether to include the object in the PostScript output of the report.

Data type: Boolean
Export to Report Result Page Report, Web Report, Library Component Specifies whether to include the object when you preview the report in Page Report Result for a page report or Web Report Result for a web report in Designer, and when users run the report or use the library component at runtime.

Data type: Boolean
Export to RTF Page Report, Web Report, Library Component Specifies whether to include the object in the RTF output of the report.

Data type: Boolean
Export to Text Page Report, Web Report, Library Component Specifies whether to include the object in the Text output of the report.

Data type: Boolean
Export to XML Page Report, Web Report, Library Component Specifies whether to include the object in the XML output of the report.

Data type: Boolean
Horizontal Query Page Report Specifies whether to show the table in horizontal style.

Data type: Boolean
Invisible Page Report, Web Report, Library Component Specifies whether to hide the object in the design area and in the report result. Logi Report Engine performs all the calculations that involve the object regardless of whether the object is visible or not.

Data type: Boolean
Invisible for Filter Dialogs Page Report, Web Report Specifies whether to display the object in the Apply To drop-down list of the Filter dialog box at runtime. Designer disables this property when you set Default for Filter to "true".

Data type: Boolean
Navigation Height Web Report, Library Component Specifies the height of the page for the table to display multiple pages. Type a numeric value to specify the height. If you do not specify a value, Logi Report Engine calculates the table page height at runtime.

Data type: Float

Note icon

  • For a table in a web report, this property takes effect when Enable Navigation of the table is "true".
  • If users resize the table at runtime, Logi Report Engine resets this property to the resized value.
Navigation Width Web Report, Library Component Specifies the width of the page for the table to display multiple pages. Type a numeric value to specify the width. If you do not specify a value, Logi ReportEngine calculates the table page width at runtime.

Data type: Float

Note icon

  • For a table in a web report, this property takes effect when Enable Navigation of the table is "true".
  • If users resize the table at runtime, Logi Report Engine resets this property to the resized value.
Position Page Report, Web Report, Library Component Specifies the position of the object. Choose an option from the drop-down list.

Data type: Enumeration
Record Location Page Report, Web Report, Library Component Specifies the calculation point for the properties of the object that are controlled by formulas. This property takes effect only when the object is in a banded object. Choose an option from the drop-down list.
  • default - Select to calculate the values of the properties in the default location where the object is placed.
  • page header - Select to calculate the values of the properties in the banded page header panel.
  • page footer - Select to calculate the values of the properties in the banded page footer panel.

For more information, see Example 2: Showing a Label on Every Page Except the Last.

Data type: Enumeration

Split Overflow Columns Page Report, Web Report, Library Component Specifies whether to display a big table with many columns on multiple pages if one page cannot hold all the columns, instead of cutting the overflow columns off - the default behavior (the property being "false").

When the property is "true", 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 Page Report, Web Report, Library Component Specifies whether to suppress the object in the design area and in the report result. If you suppress an object, Logi Report Engine skips all formulas and calculations that involve the object.

Data type: Boolean

Note icon When you set both the Invisible and Suppress properties of an object to "true", Suppress has the higher priority.
Suppress When Empty Query Page Report Specifies whether to display the object in the report result if no record is returned to it.

Data type: Boolean
Suppress When No Records Page Report, Web Report, Library Component Specifies whether to exclude the object in the report result when no record is returned to its parent data component.

Data type: Boolean
Border
Border Color Page Report, Web Report, Library Component

Specifies the color for the border of the object. Choose a color from the drop-down list or select Custom to customize a color in the Pick a Color dialog box, or type a hexadecimal RGB value (for example, 0xff0000) to specify a color. For a page report, you can also use a formula or edit an expression to return a color. Data type: String

Border Thickness Page Report, Web Report, Library Component Specifies the width for the border of the object. Type a numeric value to change the thickness.

Data type: Float
Bottom Line Page Report, Web Report, Library Component Specifies the line style for the bottom border of the object. Choose an option from the drop-down list.

Data type: Enumeration
Left Line Page Report, Web Report, Library Component Specifies the line style for the left border of the object. Choose an option from the drop-down list.

Data type: Enumeration
Right Line Page Report, Web Report, Library Component Specifies the line style for the right border of the object. Choose an option from the drop-down list.

Data type: Enumeration
Top Line Page Report, Web Report, Library Component Specifies the line style for the top border of the object. Choose an option from the drop-down list.

Data type: Enumeration
TOC
Anchor Display Value Page Report, Web Report, Library Component Specifies the string you want to display as the object's entry in the TOC of the report, which takes effect when the object's TOC Anchor property is "true".

Data type: String
TOC Anchor Page Report, Web Report, Library Component Specifies whether to include the object in the TOC of the report.

Data type: Boolean
Accessibility
External CSS Class Selector Query Page Report Specifies the name of the Class Selector for the object in the HTML output of the report.

Data type: String
External ID Query Page Report This property is mapped to the HTML attribute id, as specified by w3.org.

Data type: String
External Style Query Page Report This property is mapped to the HTML attribute style, as specified by w3.org.

Data type: String
Summary Query Page Report This property is mapped to the HTML attribute summary. You can use it to specify a summary of the object's purpose and structure.

Data type: String

Note icon For the Table object in web reports and library components, Logi Report Engine can only render the properties that are available in the Web Report Studio Inspector panel at runtime.

Back to top

BackPrevious Topic  Next TopicNext