Datasheet

ManualsBrandsSAP ManualsSoftware7090310

121

122

123

124

125

126

127

128

129

130

Of course DataBaseField is just a database field. SupportedOperator is any of =, <>, <, <=, >,

>=, StartsWith, Like or In.

ConstantOrParameterExpression is any expression that involves constant values, operators,

functions, and parameter fields. It cannot involve variables, control structures, or fields other than

parameter fields. By their very definition, constant and parameter expressions can be evaluated without

accessing the database.

Note:

A constant or parameter expression can evaluate to a simple value, a range value, an array value, or

an array of range values. Here are some examples of such expressions:

{?number parameter} - 3

Year ({?run date})

CurrentDate + 5

DateDiff ("q", CurrentDate, CDate("Jan 1, 1996"))

Month (Maximum ({?date range parameter}) + 15)

["Canada", "Mexico", "USA", {?enter a country}]

1000 To 5000

[5000 To 10000, 20000 To 30000, 50000 To 60000]

A complete example:

{Orders.Order Date} >= CurrentDate - 3

The program can also push down an expression that just contains a Boolean field (without the operator

and constant parts).

{Orders.Shipped}

Not {Orders.Shipped}

Consideration 3

IsNull (DataBaseField) can be pushed down.

Consideration 4

SqlExpression SupportedOperator ConstantOrParameterExpression can be pushed

down.

For example, the selection formula {@ExtendedPrice} > 1000 cannot be pushed down if {@Ex

tendedPrice} = (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