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

420
multiple query documents 359, 385
duplicating
alerters 292
queries 68
reports for drill analysis 357
tables 134
E
editing
alerters 291
breaks 224
formulas 310
variables 343
emptiness
hiding empty charts 196
Excel
saving documents as spreadsheets 399
extended syntax
modifying calculation context 318
F
Filter Editor
using for reports 248
filtering
linked documents 401
objects 85
queries 84
filters
combining on queries 89, 95, 96
combining on reports 252
creating on queries 91, 93
custom report filters 248
during drill 386
multi-value for document linking 402
operators (queries) 86
predefined on queries 89, 90
query versus report 84
quick filters 92
quick for reports 246
removing from reports 254
report versus query 246
single value for document linking 402
types of for queries 89
viewing on reports 253
footers
on tables 155
formats
creating custom cell formats 208
for cell values 199
for negative values 203
formatting
cell values 200
conditional formatting (alerters) 298
fonts and text in cells 153
free-standing cells 167
table borders
152
tables 149
forms
filtering 245, 248
templates 128
Formula Editor
using 310
formula errors
#DATASYNC 353
#DIV/0 351
#ERROR 354
#INCOMPATIBLE 352
#MULTIVALUE 351
#OVERFLOW 352
#RANK 352
#SYNTAX 352
Formula toolbar
using 308
formulas
creating 307
defining alerter conditions with 295, 299
defining alerter formatting with 298, 302
editing 310
insert in cells 163
saving as variables 311, 343
use variables to simplify 346
free-standing cells
describing 161
displaying page numbers 165
formatting 167
including DrillFilter 164
including formulas 163
including HTML code 163
including hyperlinks 163
including images 163
including LastRefreshDate
164
including text 163
inserting 162