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

Consideration 4
SqlExpression SupportedOperator
ConstantOrParameterExpression can be pushed down.
For example, the selection formula {@ExtendedPrice} > 1000 cannot
be pushed down if {@ExtendedPrice} = (Quantity * Price).
However, if the formula @ExtendedPrice is replaced with the equivalent
SQL Expression, then your record selection formula will be pushed down.
Consideration 5
When using multiple expressions that follow the above considerations,
separate them with AND and OR operators—you can also use NOT. You
can have several of each, and you can use parentheses to give priority. For
example:
{Orders.Order ID} < Minimum({?number range}) Or
{Orders.Order Amount} >= 1000
(IsNull({Customer.Region}) Or
{Customer.Region} = "BC") And
{Customer.Last Year's Sales} > 2000
For more information
• If your record selection formula does not respond as expected, see
Troubleshooting record selection formulas .
Incorporating parameter fields into record selection
formulas
Instead of displaying all of a report's data every time the report is opened,
you can create parameter fields that prompt users to specify the data they
want to see. To decrease the amount of data transferred from the database
server, incorporate these parameter fields right into your record selection
formula.
182 Crystal Reports 2008 SP3 User's Guide
Designing Optimized Web Reports 8
Using enhanced record selection formulas