You are here:

Table Tool

The Table tool creates a data or pivot table to output in a report via the Render tool.

To include a header or footer to your table, add a Report Text Tool directly below the Table tool and select Attach Text to Existing Field.

Configure the tool

Table Mode: Select a type of table. Options are: Basic or Pivot (Cross Tab). Use the Pivot mode when using data from a Cross Tab Tool.

Group By: Select the fields to group by. A separate table is created for each group of records.

Table Width: Select the width of the table.

Automatic: Sets the minimum width for the data contained within a table to display.
Percentage: Sets the percentage of the page for the table to be displayed, where 100% is the entire width of the page.
Fixed: Sets the width of the table in inches.

Pivot Style: Select the style for displaying the data in the table. This option is only available when using data from a Cross Tab tool. Compare the beginning data example to the example output for each option.

Beginning data example

LocaleDesc	Avg_Regular	XRow_Regular	XCol_Regular	Count_Regular	Avg_Special_Ed	XRow_Special_Ed	XCol_Special_Ed	Count_Special_Ed	Avg_Voc_Tech_Other	XRow_Voc_Tech_Other	XCol_Voc_Tech_Other	Count_Voc_Tech_Other	Total
Central City	57	97	15	1	0	0	0	0	2	3	8	1	59
Rural	182	97	49	1	0	0	0	0	6	3	23	1	188
Town	116	87	31	1	1	1	50	1	16	12	62	1	133
Unknown	5	63	1	1	1	13	50	1	2	25	8	1	8
Urban Fringe	9	100	2	1	0	0	0	0	0	0	0	0	9
Total	74	93	100	5	1	1	100	2	7	7	100	4	397

Methodology over Variable: The method for aggregating the data displays above the data field selected.

Example output

		Avg			XRow			XCol			Count
LocaleDesc	TotCol	Regular	Special Ed	Voc/Tech/Other	Regular	Special Ed	Voc/Tech/Other	Regular	Special Ed	Voc/Tech/Other	Regular	Special Ed	Voc/Tech/Other
Central City	59	57	0	2	97	0	3	15	0	8	1	0	1
Rural	188	182	0	6	97	0	3	49	0	23	1	0	1
Town	133	116	1	16	87	1	12	31	50	62	1	1	1
Unknown	8	5	1	2	63	13	25	1	50	8	1	1	1
Urban Fringe	9	9	0	0	100	0	0	2	0	0	1	0	0
Total	397	74	1	7	93	1	7	100	100	100	5	2	4

Variable over Methodology: The data field selected displays above the method for aggregating the data.

Example output

		Regular			Special Ed			Voc/Tech/Other
LocaleDesc	TotCol	Avg	XRow	XCol	Count	Avg	XRow	XCol	Count	Avg	XRow	XCol	Count
Central City	59	57	97	15	1	0	0	0	0	2	3	8	1
Rural	188	182	97	49	1	0	0	0	0	6	3	23	1
Town	133	116	87	31	1	1	1	50	1	16	12	62	1
Unknown	8	5	63	1	1	1	13	50	1	2	25	8	1
Urban Fringe	9	9	100	2	1	0	0	0	0	0	0	0	0
Total	397	74	93	100	5	1	1	100	2	7	7	100	4

Pivot Methodology to the Left: The method for aggregating the data displays on the left side for each row of data in the table.

Example output

LocaleDesc	TotCol				Regular			Special Ed			Voc/Tech/Other
Central City	59	Avg	57	0	2	Central City	59	Avg	57	0	2	Central City	59
		XRow	97	0	3			XRow	97	0	3
		XCol	15	0	8			XCol	15	0	8
		Count	1	0	1			Count	1	0	1
Rural	188	Avg	182	0	6	Rural	188	Avg	182	0	6	Rural	188
		XRow	97	0	3			XRow	97	0	3
		XCol	49	0	23			XCol	49	0	23

Pivot Variable to the Left: The data displays in the table on the left side of the method for aggregating the data.

Example output

LocaleDesc	TotCol				Avg			XRow			XCol
Central City	59	Regular	57	97	15	1	Central City	59	Regular	57	97	15	1
		Special Ed	0	0	0	0			Special Ed	0	0	0	0
		Voc/Tech/Other	2	3	8	1			Voc/Tech/Other	2	3	8	1
Rural	188	Regular	182	97	49	1	Rural	188	Regular	182	97	49	1
		Special Ed	0	0	0	0			Special Ed	0	0	0	0
		Voc/Tech/Other	6	3	23	1			Voc/Tech/Other	6	3	23	1
Town	133	Regular	116	87	31	1	Town	133	Regular	116	87	31	1

Bar Graph: Specify the data field to create a bar graph for in the table. This option is only available for a basic table. Click Settings to modify the style of the bar graph.

Show Column Headings: Displays column headings in the table. This option cannot be deselected for a pivot table.

Per Column/Methodology Configuration: If the table mode is Basic, configure the columns and if the table mode is Pivot, then configure the methodologies.

Select the data fields to include in the table.

Click a data field and use the up and down arrows to change the order the data displays in the table.

Click a data field to configure the following attributes:

Rename Field: Type a new name for the data field.
Width: Select Automatic, Percentage or Fixed for the width of the data within a column.
Alignment (H): Select the horizontal alignment of left, center, or right.
Borders: Select to have borders on the left or right sides, or both sides, or to not have any borders.
Prefix: Type text to add before the data.
Suffix: Type text to add after the data.
Dec. Places: Select the number of decimal places to include.
Column Rules: Create or edit a rule to apply to a column of data. See the Table Style Rules page for style options.

Default Table Settings: Modify style options for the table. See the Table Settings Style Editor page for style options.

Create/Edit Row Rule: Create or edit a rule to apply to a column of data. See the Table Style Rules page for style options.

Because this tool includes an expression editor, an additional input anchor displays when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor. See Interface Tools.