Help with Select Expert for SQL on Crystal 8.5

[ChrisH2]

Hello all,

I am a newbie to Crystal reporting so please bear with me. I want to incorporate the following SQL statement in my select expert so that the records are selected at the server.

SELECT CustCode, CustName, AccBal, CreditLimit FROM CUSTOMER Where AccBal > CreditLimit

The problem is that I can only know how to do this as a composite formula, which filters the record set locally and not down at the server.

Thanks in advance,

Chris

 

[rogar]

Just insert the fields CustCode, CustName, AccBal, CreditLimit into your report and create a record selection formula: {AccBal} > {CreditLimit). CR will generate the SQL statement you want - just look at the menu Database/View SQL Statement to verify. If your database system allows this SQL to be processed on the server, it will.

 

[kenhamady]

The expression:

AccBal > CreditLimit

May not make it to the SQL. You might try writing this expression in the CR SQL expression editor, and then using the expression field in the select expert. This might force it into the WHERE clause. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com