User`s guide

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).
6.5.2.3 SQL Databases
• You can push down record selection on indexed or non-indexed fields.
• Your SQL server will respond faster if you use indexed fields.
• You can push down AND and OR clauses.
• Record selection formulas containing some types of embedded formulas can be pushed down.
• You should incorporate SQL Expression fields to push down formula calculations necessary for the
record selection.
• On the Database menu, click Show SQL Query to view the SQL that will be sent to the database
server.
6.5.3 Strategies for writing efficient record selection formulas
Note:
This section assumes that you are familiar with the Select Expert and that you are reporting off of a
SQL database.
Consider the following points when creating a record selection formula:
Consideration 1
Any record selection formula that you generate completely with the Select Expert, without writing pieces
of the formula yourself, can be pushed down.
This case actually follows from the points below. However, you can write more types of record selection
formulas using the tips below than is possible with the Select Expert. To do this, you need to edit the
record selection formula directly with the Formula Workshop or from within the text area that appears
when you click Show Formula in the Select Expert.
2012-03-14121
Designing Optimized Web Reports