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

Using SQL Expressions for groups, sorts, and totals.........................188
Using SQL Expressions for Case Logic.............................................188
Inserting summary and running total fields where possible...............189
Record Selection 191 Chapter 9
Selecting records.....................................................................................192
Options for selecting records..............................................................192
Determining which field(s) to use.......................................................192
Using the Select Expert......................................................................193
Using formulas...................................................................................195
Interaction of the Select Expert and the Formula Editor....................196
To view the Select Expert formula......................................................197
Saved data selection formulas...........................................................199
Using formula templates..........................................................................199
Record selection formula templates...................................................199
Pushing down record selection to the database server...........................202
Troubleshooting record selection formulas .............................................203
To troubleshoot record selection formulas.........................................203
Correcting selections that do not generate data................................205
Sorting, Grouping, and Totaling 209 Chapter 10
Sorting data.............................................................................................210
Understanding sort options................................................................210
Sorting single and multiple fields........................................................213
Sort controls ......................................................................................215
Grouping data..........................................................................................217
Group and sort direction.....................................................................218
Creating custom groups.....................................................................220
Sorting groups conditionally...............................................................221
Sorting records within groups.............................................................223
8 Crystal Reports 2008 SP3 User's Guide
Contents