Table Tool
The Table tool creates a data or pivot table to output in a report via the Render tool.
Table headers and footers
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.
- 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. For style options, see Table Style Rules.
Default Table Settings: Modify style options for the table. For style options, see Table Settings Style Editor.
Create/Edit Row Rule: Create or edit a rule to apply to a column of data. For style options, see Table Style Rules.
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.