SQL pass through 1

[princessinthetower]

I am using Crystal 9.2 on Oracle 9. I've read the FAQ 767-3825 with interest in getting better performance because the 'Accessing Database' stage is long.

This is not being passed as SQL from record selection:

(
if {?Exclude 1M} = 'Y'
then
{@Capacity>1M} = false
else if {?Exclude 1M} = 'N'
then
{@Capacity>1M} = true or {@Capacity>1M} = false
)

Based on the parameter the report selects either all prospects or just those who do not have a $1 million donor capacity (they get special treatment).

Any clue why this would not pass? Do you have to use the Oracle native driver as opposed to the RDO ODBC driver?

 

[synapsevampire]

Since you're referencing the formula @Capacity, you need to post the formula.

In general try to use a SQL Expression in lieu of a Crystal formula within the record selection, meaning that it will be processed on the database.

Since the formula is within Crystal, it needs to pass the data back to Crystal to determine if it meets the criteria, depending upon the complexity of the formula and what it does.

-k