Dimension Elements Layout

Dimension elements layout can be set up using the Layout side panel tab and the

Layout panel on the Designer ribbon tab. Tab view and settings depend on selected element of the table, dimension, level.

Select the heading, sidehead, dimension or level, for which layout must be set up.
Select the Layout tab on the side panel in the group of tabs with settings of table, dimension, level element.

NOTE. The group of tabs is renamed according to the selected element of table, dimension, level: if sidehead or heading are selected, the tab is named Header; if the dimension is selected, it is named Dimension; if level is selected, it is named Level.

Table Sidehead and Heading Settings

If heading or sidehead are selected, the layout settings applied to table heading and sidehead will be available on the Layout tab:

To arrange elements of different levels in different columns, select the Level Elements to Separate Columns checkbox. The source table is shown on the left, the table after the checkbox is selected is on the right:

Duplicate cells appear on selecting the Level Elements to Separate Columns checkbox on the Layout side panel tab.

To show or hide duplicate cells in the data table, 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 where the Level Elements to Separate Columns checkbox is selected is shown on the left, the table with the Level Elements to Separate Columns and Show Duplicate Cells checkboxes are selected 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 where the Level Elements to Separate Columns and Show Duplicate Cells checkboxes are selected is shown on the left, the table with the Level Elements to Separate Columns, Show Duplicate Cells and Merge checkboxes are selected on the right:

The Merge checkbox is available and selected by default if the Show Duplicate Cells checkbox is selected.

To show or hide expanders for parent elements of hierarchy:

Select or deselect the Expanders checkbox on the Layout side panel tab.
Determine behavior of expanders on report refresh. To do this, select one of the radio buttons:

Collapse. Dimension hierarchy is collapsed on report refresh.
Expand. 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 with expanders:

When expanders are hidden, all collapsed child elements will be expanded in the table:

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.

Select the Use Stairs Hierarchy checkbox to apply stairs hierarchy.

The example of a table without stairs hierarchy:

The example of a table with stairs hierarchy:

In order child elements are displayed before parent ones, select the Child Elements Before Parent checkbox:

In order parent elements of hierarchy are displayed before and after children, select the Repeat Level Element for Children checkbox:

To set margins for child element names, enter or select margin size in millimeters in the Level Elements Margins value editor.

The table below shows the margin 15 millimeters and child elements are displayed before the parent ones:

To show or hide sorting icons , select or deselect the Show Rows Sorting Icons/Show Columns Sorting Icons checkbox.

To show or hide numbering of row or column headers, select or deselect the Use Numbering checkbox.

Settings of Table Dimensions and Levels

If a dimension or a level of the table is selected, settings for applying to table dimension/level will be available on the Layout tab:

Layout settings for dimensions are similar to heading and sidehead settings. By default, layout settings are inherited from heading and sidehead to dimension and from dimension to levels.

When the Leaves Only checkbox is selected, only elements without child elements are displayed in the table.

In order parent elements of leaves are displayed, select the Display Parent Elements checkbox. After this, the table will display the leaves and their parent elements. If there is at least one leaf at the parent element level, all elements on that level will appear in the table, regardless of the state of the Display Parent Elements checkbox.

NOTE. Displaying parent elements is available only for dimensions if the Leaves Only checkbox is selected and the Separating Level Elements option is used (equivalent to the Level Elements to Separate Columns checkbox for the heading/sidehead). If separation of level elements is not set up, when the Display Parent Elements checkbox is selected, it will be prompted to enable the option for dimension settings.

The Merge checkbox is available when the In One Column/Row with the Previous checkbox is selected:

After the checkbox is selected, the following parameters are available:

Merge Element. Select element that will be merged with the previous in one cell. All elements of the current dimension are displayed. The first list element is selected by default.
Element Name. Select the name type in the merged cell from the list:

Source. It displays source element name.
From Merged. It displays merged element name.
Composite. It displays name of source and merged elements.

NOTE. Depending on the selected name, the formatting is changed, which is applied to merged elements.

Delimiter. Determine a delimiter between names of merged elements in the edit box. The item is available when the Composite name type is selected.

When parameters are selected, the Elements in One Cell with Elements of the Previous checkbox is also selected.

NOTE. The merging setup is available for all dimensions, except for the top in the heading and the leftmost in the sidehead.

The first drop-down list controls expander visibility:

Inherit From. The behavior is identical to the Expanders checkbox in heading or sidehead settings.
With Expanders. Expanders of this level or dimension are displayed.
Without Expanders. Expanders of this level or dimension are hidden.

The example of a table with expanders:

When expanders are hidden, all collapsed child elements will be expanded in the table:

Position

It determines expander position on using several dimension names:

In All Names. Expanders are displayed for each name.
Fixed. Expanders are displayed only for the name specified in the Position box.

NOTE. Position setup is available only for dimensions.

The example of fixed expander displaying:

Behavior of Expanders on Calculation

It determines expander behavior on report refresh or selection change.

Inherit From. The behavior is identical to the Calculation Behavior expander radio button in heading or sidehead settings.
Collapse. Dimension hierarchy will be collapsed on report refresh or selection change.
Expand. Dimension hierarchy will be expanded on report refresh or selection change.

Padding settings are available only for dimensions.

The first drop-down list controls whether there are paddings for hierarchy child elements:

Inherit From. The behavior is identical to the Level Elements Margins checkbox in heading or sidehead settings.
With Paddings. This dimension will contain margins for level elements.
Without Paddings. This dimension will not contain margins for level elements.

The example of a table with margins and displaying of child elements before the parent ones:

Position

It determines position of paddings on using several dimension names:

In All Names. Paddings are displayed for each name.
Fixed. Paddings are set only for the name specified in the Position box.

The example of fixed padding displaying:

Size

It determines padding size.

Inherit From. Padding size is identical to value of the Level Elements Margins box in heading or sidehead settings.
Manually. Dimension padding size is set manually in the next box.

If the Inherit From option is selected, behavior is the same as the Element Levels to Separate Columns checkbox in heading or sidehead settings.

To arrange different levels in one column, select the Do Not Separate item.

To arrange different levels in separate columns, select the Separate item:

If the Inherit From option is selected, behavior is the same as the Child Elements Before Parent checkbox in heading or sidehead settings.

To display child elements of the hierarchy after parents, select the After Parent item.

To display child elements of the hierarchy before parent, select the Before Parent item:

If the Inherit From option is selected, behavior is the same as the Repeat Level Element for Children checkbox in heading or sidehead settings.

To display parent elements after or before children, select the Do Not Repeat item.

To display parent elements of the hierarchy after or before children, select the Repeat item:

Manage Hierarchy Displaying

If displaying of expanders is set up for dimensions and their levels, a hierarchy can be quickly collapsed or expanded. To do this:

Changing of hierarchy displaying affects only table appearance and does not affect element selection.