Section in report

Case:

In a report you can work with ‘sections’ to make a grouping more visible. For example you want to show some charts with sales data for each branch of the company.

Solution:

Create a table with ordernumber, product and some fact data.sectioning_1

Run the report to see the result:

sectioning_2

Click once on the column ordernumber.

In the toolbar click on the ‘section’ button.

sectioning_3

Branch now becomes a header and beneath it shows the relevant data for this branch.

sectioning_4

Run the report to see the result:

sectioning_5

Enhancements:

When you run the report you wil only see the ordernumber in the header of the section.

You can put the text “Ordernumber:” in front of it.

Do this by click once on the section title

Click on the lock to unlock the report. 

unlock

Now drag a new text item from the toolbox to the left of the section-item.

Type the text “Branch: ” in the text box.

Lock the report again and run the report to see the result.

Leave a Reply

Your email address will not be published. Required fields are marked *