Organizing a Report into Sections

You can organize data in a block using a section.

A section displays the grouped value and appears as a header outside the block, instead of remaining within the block. More importantly, a break merely groups data within a block, whereas a section groups the entire report. When you have multiple tables and charts in a single report, the sections group the data for all tables and charts according to the section value.

The advantages of sections are as follows:

• You can project multiple blocks from the same micro cube within a single report, all sub-grouped to the sectioned level.
• You can insert subtotal cells, repeated in each section, which are created by the simple process of drag-and-drop.

Insert a Section

Create a section with the contextual menu:

Section Format

You can format your report and report elements in order to present the report with a company style.

Select a section and the Format tab to view formatting settings.

The table lists the Display settings:

The table lists the Appearance settings:

The table lists the Layout settings:

You can hide and display report data by folding and unfolding report elements.

You can fold and unfold sections, breaks and tables if they have a header or a footer. Data is concealed and displayed in different ways depending on the report element.