Breaks defined
A break is a division within a block in which data is grouped according to a selected dimension, detail, or measure into self contained sections. These sections are represented as smaller tables within the same block of data. You use breaks to display all the data for each unique value of an object in separate parts.
Using breaks has two main advantages:
• You can more efficiently organize how your data is represented. • You can display subtotals.
Breaks compared to sections
A section breaks up the data into multiple free-standing cells called section headers. Each section header contains one value for a dimension, with a block of data that corresponds to the dimension value.
A break divides the data up within one block. One column contains the values for a dimension, detail, or measure, which are repeated for each other row of values in the block.
Default sort order in breaks
When you insert a break on an object, the values for the object are automatically sorted in ascending order as follows:
• If the values are numeric, the lowest value appears in the first row of the table, the highest in the last row.
• If the values are alphabetical characters, then the values are sorted in alphabetical order from top to bottom.
You can change this sort order at any time.
Building reports with the SAP BusinessObjects Web Intelligence HTML Report Panel 81
6
Organizing data with sections, breaks and sortsYou can set multiple breaks and set a sort priority on each break, so that you control how the data is displayed when you insert multiple breaks across several dimensions details, or measures.
To insert a break
1. Make sure you are in Edit mode with the HTML Report Panel open and verify you are on thePropertiestab. If thePropertiestab is not visible, select theMore report optionscheck box.
A document can contain multiple reports. The name of the selected report appears in theCurrent reportdrop-down list box.
2. Leave the displayed report selected, or select a different report by clicking the arrow next to theCurrent reportdrop-down list box, and then select a different report from the list.
TheResult Previewpane displays the structure of the report block. (A block is a table, form, or chart).
3. On theResult Previewpane, click the part of the block on which you want to apply or remove a break. If you are working with a table or crosstab you can select the columns, or rows, or body. If you are working with a form you can select the title or value.
4. Select the object on which you want to apply or remove the break. For example, if you want to break up the table values for each quarter, select [Quarter].
5. The next step depends on whether you want to apply or remove a break. If you want to apply a break, select theBreakcheck box. If you want to remove a break, unselect theBreakcheck box.
You can apply other modifications to the document using the tabs on the HTML Report Panel or run the report now to view the results.
6. ClickRun, if you are generating the results for the first time, or clickApply, if you have already generated the results once.
Break properties
You can define the following properties for a break: Organizing data with sections, breaks and sorts
Description Break property
When selected, a header is displayed for each break.
Show Break Header
When selected, a footer is displayed for each break.
Show Break Footer
When selected, a break is only inserted for each unique value of the selected break object.
Remove Duplicates
Each break starts on a new page. Start on new page
To set break properties
1. Make sure you are in Edit mode with the HTML Report Panel open and verify you are on thePropertiestab. If thePropertiestab is not visible, select theMore report optionscheck box.
A document can contain multiple reports. The name of the selected report appears in theCurrent reportdrop-down list box.
2. Leave the displayed report selected, or select a different report by clicking the arrow next to theCurrent reportdrop-down list box, and then select a different report from the list.
The Result Preview pane displays the structure of the report block. (A block is a table, form, or chart).
3. On theResult Previewpane, click the part of the block on which you want to apply or remove a break.
4. Select the break whose properties you want to set. 5. Select or clear break properties check boxes as required.
You can apply other modifications to the document using the tabs on the HTML Report Panel or run the report now to view the results.
6. ClickRun, if you are generating the results for the first time, or clickApply, if you have already generated the results once.
Building reports with the SAP BusinessObjects Web Intelligence HTML Report Panel 83
6
Organizing data with sections, breaks and sortsOrganizing data with sections, breaks and sorts