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

Building Reports Using the Web Intelligence Java Report Panel 221
• When you create a break on Year, the data remains as one block. The year values are
repeated for each corresponding value of State and Sales Revenue.
• When you create a section on Year, the data is no longer contained in one block, but
divided into sections. One section for each value of Year. Each section is a separate
block.
The difference between a break and a section is shown below:
How is data sorted when you insert a break?
When you insert a break on a dimension, the values for the dimension are automatically
sorted in ascending order. 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. For information on how to apply sorts, see ”Using sorts to organize
sections and data on tables” on page 226.
You 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. For more
information on setting multiple breaks, see the section ”Using multiple breaks” on
page 223. Inserting and removing breaks in each view is described in the following
sections.
Inserting breaks
You can insert one or multiple breaks on a table or crosstab. You can insert breaks on any
columns or rows that display values for dimensions or details.
Note: You cannot insert a break on columns or rows that display a measure.
For a complete description and examples of dimensions, details, and measures, see
”What types of objects can you use in a query?” on page 35.
one
block
one
block
one
block
Break on Year Section on Section on Year