General

  Report Design Component Palette Icon:

  


IULocgo


Simple Table


Description

With the Simple Table, you can very quickly add a table inside a reportThe Simple Table is a grid-like table structure that dynamically creates new rows and columns for rows returned by the Data Keys on the component.  To learn more about the Simple Table, refer to the CrossTab and Simple Tables page.

Note: When creating an XLS file of a report that contains a Simple Table, the content in the Simple Table will be added as an editable overlay. To create an XLS file that places the data directly into cells on the spreadsheet, use a Table component instead. 


Simple Table Properties
Table PropertiesPropertyDescriptionCategory

Data KeyThe data key associated with this Tabular component. Should be the data key of a data source that contains rows, such as a query.Table
ColumnsNumber of 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
Header ColumnsNumber of Header Columns.Table
Header RowsNumber of Header Rows.Table
RowsNumber of Rows.Table
Style

Give the CrossTab or Simple Table a pre-configured style.

  • None
  • Classic 1 through Classic 3
  • Default
  • Elegant - with double border around the table.
  • Grid 1 through Grid 8
  • List 1 through List 6
  • Professional
  • Simple 1 through Simple 6

The Style section below shows several examples of some of the style templates you can choose from.

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 Style

What 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
URL

The following feature is new in Ignition version 8.1.19
Click here to check out the other new features
A link to attach to this reporting component. Will be a clickable hyperlink if the report is exported as a PDF. You can use the values below to link to internal pages.

ValueDescription
Page:NextNavigates to the next page.
Page:BackNavigates to the previous page.
Page:NumberReplace "Number" with a numeral. Navigates to the specified page.
Basic Properties

Visible

If 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 to the left edge of the page.Basic Properties
YVertical distance in pixels between the upper edge of this shape to the top edge of the page.Basic Properties


Cell Properties and Functions
Cell PropertiesPropertyDescriptionCategory


TextText to display in the shape.Text Properties
Text ColorColor of the text.Text Properties
Character SpacingAmount of extra spacing to add between characters. Negative spacing makes characters closer together.Text Properties
Coalesce NewlinesIf true, consecutive line breaks will be merged into one.Text Properties
FontFont to use for the text.Text Properties
Horizontal AlignmentHorizontal Alignment for text: Left; Right; Center; Full.Text Properties
Line SpacingSpacing between lines of text. 1 is single spacing, 2 is double spacing, etc.Text Properties
MarginMargin between texts and bounds of shape in pixels. Format is top: left: bottom; right.Text Properties
Overflow BehaviorHow text that overflows the bounds of the shape should be handled.
  • Shrink text to fit - text fits into the shape, and the font is smaller when previewed or printed.
  • Grow row - text fits into the shape, and shows when the shape is expanded, previewed, or printed.
Text Properties
UnderlinedIf true, use underlined text.Text Properties
Vertical Alignment

Vertical alignment for text: Top; Middle; Bottom.

Text Properties
Date FormatFormats to use for dates in this shape. Data Key and Format Properties
Null FormatFormats to use for null values in this shape.Data Key and Format Properties
Number FormatFormats to use for numbers in this shape. Data Key and Format Properties
Negative in RedIf true, show negative numbers in red.Data Key and Format Properties
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 Style

What 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
Show Top Divider

The following feature is new in Ignition version 8.1.12
Click here to check out the other new features
If true, show top divider.

Stroke and Fill
Show Left Divider

The following feature is new in Ignition version 8.1.12
Click here to check out the other new features
If true, show left divider.

Stroke and Fill
Show Bottom Divider

The following feature is new in Ignition version 8.1.12
Click here to check out the other new features
If true, show bottom divider.

Stroke and Fill
Show Right Divider

The following feature is new in Ignition version 8.1.12
Click here to check out the other new features
If true, show right divider.

Stroke and Fill
GroupingGrouping Key will add a row or column for each Grouping the key generates.Grouping
RadiusAmount to radius the corners of this shape.Rectangle Shape
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
URL

The following feature is new in Ignition version 8.1.19
Click here to check out the other new features
A link to attach to this reporting component. Will be a clickable hyperlink if the report is exported as a PDF. You can use the values below to link to internal pages.

ValueDescription
Page:NextNavigates to the next page.
Page:BackNavigates to the previous page.
Page:NumberReplace "Number" with a numeral. Navigates to the specified page.
Basic Properties
VisibleIf true, the shape will be visible.Basic Properties

Width

Width of this shape in pixels.

This feature was changed in Ignition version 8.1.12:

As of 8.1.12, this property is read-only.
Basic Properties
Height

Height of this shape in pixels.

This feature was changed in Ignition version 8.1.12:

As of 8.1.12, this property is read-only.
Basic Properties
X

Horizontal distance in pixels between the left edge of this shape and the left edge of the page.

This feature was changed in Ignition version 8.1.12:

As of 8.1.12, this property is read-only.
Basic Properties
Y

Vertical distance in pixels between the upper edge of this shape and the top edge of the page.

This feature was changed in Ignition version 8.1.12:

As of 8.1.12, this property is read-only.
Basic Properties

Cells have a functions feature. Double click on a cell and then right click to see the functions. All the functions are the same for any cell that is selected.

Cell FunctionsFunctionDescription

Clear ContentsDeletes all contents from the selected cell.
Add Row AboveAdds a row above the selected cell.
Add Row BelowAdds a row below the selected cell.
Add Column BeforeAdds a column before the selected cell.
Add Column AfterAdds a column after the selected cell.
Remove RowRemoves the selected row.
Remove ColumnRemoves the selected column.
Merge CellsCombines the selected cells.
Split CellSplits the selected cell into individual cells.


Reserved Column Names

Besides the built-in keys for the Reporting Module's Table component, there are several reserved names that should not be used as keys for column headers. These keys are broken down into categories in the following table:

Key Type

Key

Heritage/Top LevelRunning
Heritage/Top LevelRemaining
Heritage/Top LevelUp
Aggregatetotal
Aggregateaverage
Aggregatecount
AggregatecountDeep
Aggregatemax
Aggregatemin


Example

This Simple Table shows the total number of downtime events and downtime minutes, as well as the average number of downtime minutes for each piece of equipment.


The Simple Table uses the Show Calculation property in the Key Browser and several of the Built-in Keys: 'count', 'total', and 'average.' Other properties were modified to make the column headers and row headers stand out. Double click on the cell to change the property values for that cell. The property values for this example are shown in the property list below.

Simple Table in the Design PanelPropertyValue






StyleDefault
Columns1
Header Columns1
Rows3
Column HeaderEquipment
Header in Row 1Downtime Count
Header in Row 2Total DT Duration (Min)
Header in Row 3AVG DT Duration (Min)
Header Rows Color0000D9, Bold
Header Column Color0000D9, Bold


Equipment Downtime Dataset - used for this Simple Table example.

Equipment, Duration_minutes
"Motor", 52 
"Conveyor", 154
"Palletizer", 58
"Pallet Wrapper", 251
"Motor", 33 
"Conveyor", 94 
"Palletizer", 10 
"Pallet Wrapper", 25
"Motor", 23 
"Conveyor", 60 
"Palletizer", 32
"Pallet Wrapper", 25
"Motor", 12 
"Conveyor", 33 
"Palletizer", 8
"Pallet Wrapper", 25
"Motor", 24 
"Conveyor", 124
"Palletizer", 75 
"Pallet Wrapper", 25
"Motor", 43 
"Conveyor", 51 
"Palletizer", 120
"Pallet Wrapper", 25
"Motor", 13 
"Conveyor", 36
"Palletizer",39
"Pallet Wrapper", 25
"Motor", 18 
"Conveyor", 45 
"Palletizer", 65
"Pallet Wrapper", 25


  • No labels