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 327
You have a report showing Year, Quarter and Sales revenue. The report has a
column, Report Total, that shows the total of all revenue in the report.
The formula for the Report Total column is
Sum([Sales revenue]) In Report. Without the Report
keyword, this column would duplicate the figures in the Sales Revenue column because it
would use the default output context ([Year];[Quarter]). For more information on default
contexts, see ”Default calculation contexts” on page 314.
The Section keyword
The following table describes the data referenced by the Section keyword depending on
where it is placed in a report
Example: The Section keyword
You have a report showing Year, Quarter, and Sales revenue. The report has a
section based on Year. The Section Total column has the formula:
When placed in... References this data...
A block All data in the section
A block break (header or
footer)
All data in the section
A section All data in the section
Outside any blocks or sections Not applicable