HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Using sections, breaks, and sorts220
You can format the text, background, borders, and page layout position of section
cells. For information on how to do this, see ”Formatting free-standing cells” on
page 167.
Using breaks to group data on tables
This section explains how to break up data in tables and crosstabs and describes the
different options available to format and manage these breaks.
What is a break?
A break is a division in a result table in which data is grouped according to a selected
value into self-contained parts. These parts are represented as smaller tables.
You use breaks to display all the data for each unique value of a dimension in separate
tables.
Using breaks has two main advantages:
• you can more efficiently organize how your data is represented
• you can display subtotals
Example: How can I show revenue subtotals for each state in a table?
The table on the left displays the revenue per year per state with the total revenue
displayed at the bottom of the table. The table on the right displays the same data but, by
organizing the data by state, you can now show a subtotal for the revenue generated by
each state for the years 2001-2003. A mini table is created for each of the three values of
state. This separation, however, is only visual as the three mini tables still belong to a
single table.
How is a break different from a section?
The example below shows sales revenue for each state sorted by year. The resulting data
is presented differently as follows: