Datasheet

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.
To open the Formula Workshop to modify record selection, click the Report menu, point to Selection
Formulas, and then select Record from the submenu.
Consideration 2
To open the Formula Workshop to modify record selection, click the Report menu, point to Selection
Formulas, and then select Record from the submenu.
Any selection formula that is of the form: DataBaseField SupportedOperator ConstantOrPa
rameterExpression can be pushed down.
2011-05-16121
Designing Optimized Web Reports