HP Intelligent Management Center Standard Software Platform - Manual (Page 7)

To delete an object from the repository..............................................159
Using Undo in the repository...................................................................159
Designing Optimized Web Reports 161 Chapter 8
Overview..................................................................................................162
Key strategies for optimizing web reports..........................................163
Scale with BusinessObjects Enterprise...................................................163
Evaluation times for date functions in BusinessObjects Enterprise....165
Making the right design choices..............................................................166
Using faster report formats.................................................................166
Choosing between live and saved data.............................................167
Designing summary reports...............................................................169
To hide details in a summary report...................................................170
Using subreports carefully..................................................................170
Using other design elements effectively.............................................172
Designing reports to maximize data sharing......................................173
Streamlining your reporting environment.................................................174
Selecting the fastest database and connection..................................174
Using table indexes............................................................................174
Improving table-linking choices..........................................................174
Using thread-safe database drivers...................................................176
Using stored procedures for faster processing..................................177
Using enhanced record selection formulas ............................................177
Pushing down record selection—an example....................................178
Record selection performance tips.....................................................179
Strategies for writing efficient record selection formulas ...................180
Incorporating parameter fields into record selection formulas ..........182
Using SQL expressions where appropriate........................................185
Improving grouping, sorting, and totaling ...............................................186
Performing grouping on server...........................................................186
Benefits of grouping on server—an example.....................................187
Crystal Reports 2008 SP3 User's Guide 7
Contents