Datasheet

formula is evaluated by Crystal Reports, no further records need to be eliminated. Click Show SQL
Query on the Database menu and notice that the resulting SQL query has a WHERE clause.
As this example shows, your report's processing speed improves when you enhance your record
selection formula. In this case, both formulas generate the same report, but the second takes advantages
of the power and optimizations that the database server can use when handling its own data.
Tip:
See the next section for additional information and limitations when setting up record selection requests.
Note:
If you are new to record selection formulas, you may prefer to begin with the Select Expert or the sample
record selection formula templates. For further details, along with an introduction to record selection,
see Selecting records.
6.5.2 Record selection performance tips
Consider the following performance-related items when setting up record selection requests:
6.5.2.1 General
• To push down record selection, you must select "Use Indexes or Server for Speed" in the Report
Options dialog box (available on the File menu).
• In record selection formulas, avoid data type conversions on fields that are not parameter fields.
For example, avoid using ToText( ) to convert a numeric database field to a string database field.
• You are able to push down some record selection formulas that use constant expressions.
6.5.2.2 PC Databases
• You can only push down record selection on indexed fields.
• You can only push down AND clauses (not OR).
2011-05-16120
Designing Optimized Web Reports