Skip to end of metadata
Go to start of metadata


CrossTab Table

Report Design Component Palette Icon:


IULocgo


CrossTab Table

Description

CrossTab Table are commonly used to summarize the relationship between two categories of data by showing summaries of cross sections of the data source.  The CrossTab Table allows you to very quickly show cross sections of data where the other table types are focused on a dynamic number of rows and columns. CrossTab data should contain the following:

  • Lots of repetitious data. Sums, Averages, and other Aggregating functions are well represented by CrossTab Tables.
  • A data source that provides at least two columns of data which are repetitious compared to the number of rows.  
  • One or more columns that represent a value that requires calculation.  Examples are: summing money, displaying average response times, counting occurrences, etc.   These calculations may be provided as columns or calculations of the data source, or as Keychain Expressions.

CrossTab tables can be customized using table and cell properties. It also has a number of style templates. Select any one of the style templates, use as is, or double click on any of the cells to change the individual cell's properties. Configure the style in the Design panel, and view the table with your data in the Preview panel.

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
Reprint Header RowsEnable header row printing when pagination occurs.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 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
StrokeDetails 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 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
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.
  • Paginate - text is pushed to the next page if the number of characters exceed the shape.
  • 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 AlignmentVertical 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 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
StrokeDetails for the chosen stroke. Each Stroke has its own properties depending on the Stroke Style chosen.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
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

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.


Style Templates

Here is a sampling of several pre-configured style templates. There are many more templates to choose from in the dropdown list of the Table's Style property. You can make changes to any of the pre-configured styles by double clicking on any cell in the CrossTab Table and editing the cell's properties.

Default


Elegant

Professional

Classic 1

Grid 2

List 6

Simple 3

Example

The Elegant Style template was used for this CrossTab table in a report. This CrossTab Table shows the downtime in minutes for each piece of equipment at each site.


Downtime Dataset - used for this CrossTab Table example

Downtime Dataset
Equipment,Time,Site
Motor, 15, Site A
Motor, 23, Site A
Conveyor Line, 148, Site B
Pallet Wrapper, 58, Site A
Motor, 96, Site C
Conveyor Line, 23, Site B
Palletizer, 40, Site B
Palletizer, 30, Site C
Conveyor Line, 56, Site A
Conveyor Line, 50, Site C
Pallet Wrapper, 45, Site C
Motor, 43, Site C
Palletizer, 20, Site A
Pallet Wrapper, 55, Site B
Motor, 100, Site B


The data keys were used to populate the CrossTab Table with data. The property values used to configure the CrossTab Table are shown in the property list.

CrossTab Table in Design PanelPropertyValue

StyleElegant
Text Color
(for Equipment and Site Headers)
Red
Font14
Horizontal Alignment

Center
Horizontal Alignment
(for Site)
Right

 

  • No labels