To set up table area, sidehead, heading layout, use the Layout group of parameters on the parameters panel.
Open the Layout group of parameters
To open the Layout group of parameters on the parameters panel:
Select a cell or a cell range in the table area.
Click the Parameters button on the toolbar.
Select the required area type in the drop-down menu of the parameters panel title.
Layout options depend on the selected area type.
Set the parameters:
It is available for the table area type.
To optimize cell size fit, select one mode in the drop-down list:
No. No autofit.
Width Only. The minimum required column width is set to show text of the longest cell in the table area column.
Height Only. The minimum required height is set to show text of the highest cell in the table area row.
First by Width, Then by Height. Firstly, column size is autofit, then row size is autofit.
First by Height, Then by Width. Firstly, row size is autofit, then column size is autofit.
Automatically. Autofit is executed automatically according to the determined parameters:
Maximum Text Lines in Cell. When the checkbox is selected, column width is adjusted so that no more than N rows specified in the box will be required to show text of the longest row in the cell column.
Minimum Columns. When the checkbox is selected, the table area will always display the minimum N columns specified in the box.
Simplified. This mode is set by default. Simultaneous autofit of width, height and visible data. Autofit is applied for 25 rows/columns from the beginning, middle and end of table area:
Maximum Sidehead Width. Set sidehead width, the default value is 500.
Maximum Row Height. Set row height, the default value is 50.
For example, if 50 columns are selected, autofit is applied to the entored selected element range, that is, 25 columns fron the beginning and 25 columns from the end of the table area. If 52 columns are selected, autofit is not applied to the middle.
It is available for the Sidehead and Heading area types.
To display dimension levels in different strings without repetition of parent elements in the sidehead/heading, select the Multilevel Sidehead or the Multilevel Heading checkbox.
When transposing a table area, the setting is applied for dimensions in heading after transposing.
Level elements to separate columns/rows
It is available for the Sidehead and Heading area types.
To arrange elements of different levels in different columns or rows, select the Level Elements to Separate Columns /Rows checkbox.
The source table area is shown to the left, the table area after arranging elements of different levels in different columns is shown to the right.
NOTE. Arranging elements of different levels in different columns/rows depends on the use of multilevel sidehead/heading. When the Multilevel Sidehead/Multilevel Heading checkbox is selected or deselected, the Level Elements to Separate Columns/Level Elements to Separate Rows checkbox is automatically selected or deselected. When the Multilevel Sidehead/Multilevel Heading checkbox is deselected, one can select manually the Level Elements to Separate Columns/Level Elements to Separate Rows checkbox.
It is available for the Sidehead and Heading area types.
To show or hide duplicate cells in a table area, select or deselect the Show Duplicate Cells checkbox. Duplicate cells are shown by default. If the checkbox is deselected, level name is displayed in a separate row before level elements and in a merged cell opposite to level elements.
The table area where the Level Elements to Separate Columns checkbox is selected is shown on the left, the table area with the Level Elements to Separate Columns and Show Duplicate Cells checkboxes are selected is shown on the right:
When the Merge checkbox is selected, duplicate elements will be shown only for the first cell of the level; when the checkbox is deselected, elements will be repeated for each level element.
The table area where the Level Elements to Separate Columns and Show Duplicate Cells checkboxes are selected is shown on the left, the table area with the Level Elements to Separate Columns and Show Duplicate Cells and Merge checkboxes are selected is shown on the right:
NOTE. The Merge checkbox is available and selected by default if the Show Duplicate Cells checkbox is selected.
It is available for the Heading area type.
To set up displaying of indicator names, select or deselect the required indicators in the Indicator Names drop-down list. All indicators are selected by default, and all names are displayed.
Use the Select All and Deselect All items in the context menu of the names list to select or deselect all names at once.
When transposing a table area, the setting is applied for indicators located in the sidehead after transposing, and becomes unavailable for heading dimensions.
For details about options of setting up displaying of indicator names in data entry form heading see the Examples of Use of Indicator Names Display Setup section.
It is available for the Sidehead and Heading area types.
To make the table look more compact, use context menu items of the selected dimension of the Dimensions parameter:
Merge with Previous. It is available if the table sidehead or heading contains several dimensions.
Tuck Elements. It is available only for merged dimensions of table sidehead/heading.
Set Up. It is available during element tucking setup.
Group. It is available only for the Sidehead area type. To merge elements by specified attributes, execute the following operations:
Select the Group item in the selected dimension's context menu. The Set Up Grouping dialog box opens:
Select the required attributes in the Grouped Attributes area. To do this:
Select the attribute in the Sidehead Dimensions area.
Execute one of the operations:
Drag the attribute to the Grouped Attributes area.
Click the Group button.
NOTE. Hidden attributes of dimension cannot be grouped.
Select a dictionary level for which grouping is set up. To do this, select level name in the dimension's drop-down list of the Grouped Attributes area. The Without Level option is selected by default. In this case, grouping is applied to all levels at the same time.
Place attributes in the required order:
Select the attribute in the Grouped Attributes area.
Use the Move Up and Move Down buttons.
The attributes location in the Grouped Attributes area affects the element order in the table sidehead.
Delete attributes if there is no need to use them in grouping. To do this:
Select the attribute in the Grouped Attributes area.
Execute one of the operations:
Drag the attribute to the Sidehead Dimensions area.
Click the Ungroup button.
Toggle the Hide Empty Values of Attributes switch to the active state to show only the attributes with set values. The switch is active by default. It is required to hide empty attribute values if several attributes are not specified for elements. If empty attribute values are hidden, the table displays grouped elements and then ungrouped elements, that is, those without attribute values, by which grouping is set up.
After executing the operations, the attributes, by which element grouping is executed, are assigned. Grouping is applied to elements of one dimension.
NOTE. Grouping can be set up for each dimension displayed in the sidehead, except for the dimension, for which alternative hierarchy is set up.
One can also set up sidehead elements grouping using the table area editor.
It is available for the Sidehead and Heading area types.
To set up displaying of the hierarchy, select or deselect the checkboxes:
Expanders. Show or hide expanders for parent elements of hierarchy. The checkbox is selected by default.
To determine expander behavior on report refresh, select one of the radio buttons:
Collapse. Dimension hierarchy is collapsed on report refresh.
Expand. Default value. Dimension hierarchy is expanded on report refresh.
NOTE. One can set up expander icons for table area. For details about setting up custom expanders, see the Displaying Custom Expanders article.
The example of a table area with expanders:
When expanders are hidden, all collapsed child elements will be expanded in the table area:
Use Stairs Hierarchy. If several dimensions are located by columns or rows, it is recommended to use stairs hierarchy to separate dimension elements in the sidehead or heading. The checkbox is deselected by default.
The example of a table area without stairs hierarchy:
The example of a table area with stairs hierarchy:
Child Elements before Parent. Place child elements before parent ones:
The checkbox is deselected by default.
Repeat Level Element for Children. Place parent elements before and after children:
The checkbox is deselected by default.
Level Element Paddings. Padding for child element names. The checkbox is selected by default, and the padding 3 mm is set. To change the padding, select its size or enter it in the value editor.
The table area below shows the margin 15 millimeters and child elements are displayed before the parent ones:
To sort table area data by columns and/or rows, select the corresponding checkboxes. After the checkboxes are selected, sorting icons / are displayed in row/column headers. The checkboxes are selected by default. On consequent pressing of any of the icons its view is changed, therefore the sorting type is changed:
. Descending sorting (if there are text values from Z to A).
. Ascending sorting (if there are text values from A to Z).
. Sorting is disabled.
NOTE. Sorting by rows only is available for the Sidehead area type, and sorting by column only is available for the Heading area type.
See also:
Setting Up Data Entry Form Formatting and Display Type