User`s guide

Strategies for writing efficient record selection formulas......................................................121
6.5.3
Incorporating parameter fields into record selection formulas...............................................124
6.5.4
Using SQL expressions where appropriate..........................................................................125
6.5.5
Improving grouping, sorting, and totaling..............................................................................125
6.6
Performing grouping on server.............................................................................................126
6.6.1
Benefits of grouping on server—an example........................................................................126
6.6.2
Using SQL Expressions for groups, sorts, and totals...........................................................127
6.6.3
Using SQL Expressions for Case Logic................................................................................128
6.6.4
Inserting summary and running total fields where possible....................................................128
6.6.5
Record Selection.................................................................................................................129Chapter 7
Selecting records.................................................................................................................129
7.1
Options for selecting records...............................................................................................129
7.1.1
Determining which field(s) to use.........................................................................................129
7.1.2
Using the Select Expert........................................................................................................130
7.1.3
Using formulas.....................................................................................................................132
7.1.4
Interaction of the Select Expert and the Formula Editor........................................................132
7.1.5
Saved data selection formulas..............................................................................................134
7.1.6
Using formula templates.......................................................................................................134
7.2
Record selection formula templates.....................................................................................134
7.2.1
Pushing down record selection to the database server.........................................................137
7.3
Troubleshooting record selection formulas...........................................................................137
7.4
To troubleshoot record selection formulas...........................................................................137
7.4.1
Correcting selections that do not generate data...................................................................139
7.4.2
Sorting, Grouping, and Totaling..........................................................................................141Chapter 8
Sorting data.........................................................................................................................141
8.1
Understanding sort options..................................................................................................141
8.1.1
Sorting single and multiple fields..........................................................................................143
8.1.2
Sort controls........................................................................................................................145
8.1.3
Grouping data......................................................................................................................147
8.2
Grouping data......................................................................................................................147
8.2.1
Creating custom groups.......................................................................................................149
8.2.2
Sorting groups conditionally.................................................................................................150
8.2.3
Sorting records within groups..............................................................................................151
8.2.4
Group selection...................................................................................................................152
8.2.5
Grouping data in intervals.....................................................................................................156
8.2.6
Grouping by the first letter of a company name....................................................................158
8.2.7
Grouping data hierarchically.................................................................................................159
8.2.8
Editing groups......................................................................................................................165
8.2.9
2012-03-146
Contents