Report - Simple Table

With the Simple Table, you can very quickly add a table inside a report. The 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.

Cell Properties	Property	Description	Category
	Text	Text to display in the shape.	Text Properties
	Text Color	Color of the text.	Text Properties
	Character Spacing	Amount of extra spacing to add between characters. Negative spacing makes characters closer together.	Text Properties
	Coalesce Newlines	If true, consecutive line breaks will be merged into one.	Text Properties
	Font	Font to use for the text.	Text Properties
	Horizontal Alignment	Horizontal Alignment for text: Left; Right; Center; Full.	Text Properties
	Line Spacing	Spacing between lines of text. 1 is single spacing, 2 is double spacing, etc.	Text Properties
	Margin	Margin between texts and bounds of shape in pixels. Format is top: left: bottom; right.	Text Properties
	Overflow Behavior	How 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
	Underlined	If true, use underlined text.	Text Properties
	Vertical Alignment	Vertical alignment for text: Top; Middle; Bottom.	Text Properties
	Date Format	Formats to use for dates in this shape.	Data Key and Format Properties
	Null Format	Formats to use for null values in this shape.	Data Key and Format Properties
	Number Format	Formats to use for numbers in this shape.	Data Key and Format Properties
	Negative in Red	If true, show negative numbers in red.	Data Key and Format Properties
	Fill	If true, the shape will fill its space with color.	Stroke and Fill
	Fill Color	If 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 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
	Grouping	Grouping Key will add a row or column for each Grouping the key generates.	Grouping
	Radius	Amount to radius the corners of this shape.	Rectangle Shape
	Roll	Number of degrees this shape is rotated clockwise.	Basic Properties
	Scale X	Amount to scale the width of this shape. 1 is scale to 100%.	Basic Properties
	Scale Y	Amount 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. Value Description Page:Next Navigates to the next page. Page:Back Navigates to the previous page. Page:Number Replace "Number" with a numeral. Navigates to the specified page.	Basic Properties
	Visible	If 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.

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:

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.

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