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

Displaying information in free-standing cells164
Web Intelligence displays the information you specified in the new cell.
Inserting information about the report data
You can insert special cells to show the following information about report data:
• Last refresh date – the date that the results displayed in the report were updated with
the data on the database.
For more information about setting refresh options, see
page 27.
• Drill filters – the names of the objects that filter the results displayed on a drilled report.
For more information about working with filters in drill mode, see
page 385.
You can also add a blank cell next to the Last Refresh Date or Drill Filter cell to clearly
indicate the type of information these cells display.
Example: What filters are filtering the results displayed in a drilled report?
In this example, you drill a report to analyze the reasons behind the results for line sales in
Q1. To do this, you drill down on Q1 and then drill down again on Accessories to take
a look at a breakdown of sales results for each accessories category. When you drill, the
Drill toolbar displays filters for Accessories and Q1, to show how the results displayed in
the drilled report are filtered.
You want to distribute a printout of the report at a meeting. However, the
Drill toolbar will
not be printed as part of the report and you would like readers of the printout to
understand how the results are filtered.
To let your colleagues know what that the values in the report are limited to results for Q1
and the Accessories line you include a free-standing cell with a predefined formula that
displays the filters generated during drill.
When you generate the report to a PDF format file for printing, the drill filter information
appears in the free-standing cell.
The following section tells you how to insert:
• th
e Last Refresh Date or Drill Filter free-standing cell
• text in front of the free-standing cell to label the cell contents
Inserting the Last Refresh Date or Drill Filter cell
To insert the refresh date of drill filter cell:
1. Make sure you are in Report View.
The Edit Report button is pressed in when you are in Report View.
2. Click the Templates tab.
The Template tab is bought to the foreground.
3. Click the + sign next to Free-Standing Cells.
4. Click the + sign next to Formula and Text cells.
5. Select the Drill Filters or the Last Refresh Date template, then drag the template
onto a blank area of the report.