Skip to end of metadata
Go to start of metadata



Report Table


Report Design Component Palette Icon:




Description

The Report Table displays data in a structured, repetitious format which gives reporting users the ability to flexibly layout and organize tabular data in a variety of ways. The Reporting engine automatically creates new pages to fit all data within the table's boundaries while applying formatting preferences such as font, size, layout, and alignment. Combine this feature with powerful data manipulation and layout tools, you get an object that forms the basis of your reports.

Configure Table Properties

In the Property Inspector, use the Configure Table and Properties tabs to configure your table. Here is a list of all the Table properties and their descriptions.

Configure Table TabNameDescription

Data KeyUnique identifier or placeholder that points to your data. Typically a data source is used for this property.

Grouping

Allows you to group the data by columns in the datasource. Will always at least group by the entire datasource.
Rows

Rows in a table. There are three types:

Header Row: A single row inserted at the start of the Detail Rows. Commonly used to display column headers.

Details Row: Represents the majority of the data on a table.

Summary Row: A single row inserted after all the Detail Rows. Commonly used to display totals or summary values.

Sorting

Orders data in the table. Sorting occurs after the data has already been retrieved in the data source. There are three options:

Default: Data sorted based on the order in which it is retrieved. When selected, the table will not sort the rows.

Basic: Allows a list of keys to be configured. The data is sorted in the order the keys are selected.

TopN: Uses a single key path, with a Count value that allows a limit to the number of rows that are processed.

Page BreakCreates a page break between each grouping.
Make Table GroupTurns the Table into a TableGroup, where you can add 'child' and 'peer' tables.
Table PropertiesNameDescriptionCategory

Data KeyData Key associated with the table. Should be the data key of the data source that contains rows such as a query and should match the Data Key of the Configure Table Tab.Table
Column CountThe number of columns that the table will repeat horizontally on a page before paginating. Size your table to be the width of a single column.Table
Column SpacingThe space between table columns.Table
Filter KeyA key or expression used to prune the underlying data source's rows down. If not blank, only rows for which this key expression evaluates to true will be included.Table
Starting Page BreakIf true, the table will always start on a new page if part of a table group.Table
FillIf true, the shape will fill its space with color.Stroke and Fill
Fill ColorIf Fill is selected, the color that will fill the shape.Stroke and Fill
OpacityHow opaque the fill color is, between 0 and 1.Stroke and Fill
Stroke StyleWhat style of stroke or border to use: Hidden, Shape Outline, Border, or Double. To learn more about stroke styles, refer to Stroke and Fill Properties.Stroke and Fill
Stroke

Details for the chosen stroke. Each Stroke has its own properties depending on the Stroke Style chosen.

Stroke and Fill
RollNumber of degrees this shape is rotated clockwise.Basic Properties
Scale XAmount to scale the width of this shape. 1 is scale to 100%.Basic Properties
Scale YAmount to scale the height of this shape. 1 is scale to 100%.Basic Properties
VisibleIf true, the shape will be visible.Basic Properties
WidthWidth of this shape in pixels.Basic Properties
HeightHeight of this shape in pixels.Basic Properties
XHorizontal distance in pixels between the left edge of this shape and the left edge of the page.Basic Properties
YVertical distance in pixels between the upper edge of this shape and the top edge of the page.Basic Properties


Table Group Properties

Table Groups are a collection of multiple tables represented by a single component. Examples of their use can be found on the Table Groups page.

Configure TableGroupNameIconDescription

Add Child/Peer Table

Adds a new table to the group. Allows for the creation of a Child or Peer table.

  • Child Table: A copy of this table will be inserted in between each row of the parent table
  • Peer Table: This table will appear after any preceding peers.

Note that the terms "child" and "peer" are relative to the adjacent tables. More details can be found on the Table Groups page.

Delete Table

Removes the selected table from the group.
Move Up

Moves the selected table up in the hierarchy. Tables are always presented in a Top-to-Bottom order, so your initial table should always be at the top.
Move Down

Moves the selected table down in the hierarchy.
Move Left

Moves the selected table left in the hierarchy, potentially changing the peer/child relationship with any tables listed above the selected table.
Move Right

Moves the selected table right in the hierarchy, potentially changing the peer/child relationship with any tables listed above the selected table.
Destroy Table Group

Removes the table group. Note that this will delete any configurations on all tables below the top-most table.
Start on new pageN/AAdds an explicit page break between the selected table and the prior peer table.
New page per rowN/AAdds an explicit page break for each row of the selected table.
KeyN/AThe Key of the selected table.


Row Properties

All Table Rows (Header, Details, and Summary) have the same properties, and all rows in the table use its own settings. You can click on each row to see the property values for that row. Here is a list of all the Table Row properties and their descriptions.

Row ProperertiesNameDescriptionCategory

Structured ColumnsIf true, this row will be organized into columns, otherwise, the row will allow free form design.Table Row
Column CountIf this row is structured, this is the number of columns in the row.Table Row
Move to BottomIf true, this row will be moved to the bottom of the table.Table Row
Print Empty GroupIf true, row will print even if it has no children. Only applicable for header or summary rows.Table Row
Sync Alternate VersionsIf checked, the columns widths of this row will be synchronized with alternate row versions.Table Row
Sync Row Above

If checked, the column widths of this row and the row above it will be synchronized as long as they have the same number of fields.

Table Row
Version KeyData Key to drive which version of the table row to display.Table Row
FillIf true, the shape will fill its space with color.Stroke and Fill
Fill ColorIf Fill is selected, the color that will fill the shape.Stroke and Fill

Opacity

How opaque the fill color is, between 0 and 1.Stroke and Fill
Stroke StyleWhat style of stroke or border to use: Hidden, Shape Outline, Border, or Double. To learn more about stroke styles, refer to Stroke and Fill Properties.Stroke and Fill
Stroke

Details for the chosen stroke. Each Stroke has its own properties depending on the Stroke Style chosen.

Stroke and Fill
Min. Remainder Height

Minimum distance in points between the bottom of the row that will split onto a new page. The default value of 72 points is equivalent to 1 inch.

This and Min. Split Height are how the table determines when to add another row on to a page, or split the row to a new page. If using rows with a large height (such as those that contain another component, like a chart) you may find that the row is "split" horizontally across multiple pages. Setting this and Min. Split Height to a larger number will help prevent these splits.

Pagination
Min. Split Height

Minimum distance in points between the top of the row that will split onto a new page. The default value of 72 points is equivalent to 1 inch.

Typically set to the same number as Min. Remainder Height. See the information box on the Min. Remainder Height property above.

Pagination
Page BreakData Key or expressions used to determine whether row should force a page break.Pagination
Reprint When WrappedIf true, this row will be reprinted on a new page when its children cross a page boundary.Pagination
Stay with ChildrenThe number of children this row must be accompanied by, in the case where some children run off the bottom of a page.Pagination
RollNumber of degrees this shape is rotated clockwise.Basic Properties
Scale XAmount to scale the width of this shape. 1 is scale to 100%.Basic Properties
Scale YAmount to scale the height of this shape. 1 is scale to 100%.Basic Properties
VisibleIf true, the shape will be visible.Basic Properties
WidthWidth of this shape in pixels.Basic Properties
HeightHeight of this shape in pixels.Basic Properties
XHorizontal distance in pixels between the left edge of this shape and the left edge of the page.Basic Properties
YVertical distance in pixels between the upper edge of this shape and the top edge of the page.Basic Properties



Cell Properties

The cells on the Table are simply Text Shape components embedded directly in a row. They can be multi selected with shift or alt, to change the properties of multiple cells at once. For more information, please see the Text Shape page here in the Appendix.


Examples

The Table component has a lot of functions and features. Examples of how you can use these functions and features are included in each of the sections below.

  • No labels