CR formula issue

building reports crystal reports
1

Hi,

can we create a formula in crsytal reports with where clause??PLease help

Thanks in adv
abc

abc (BOB member since 2007-06-05)

2

Hi,

You can use If then else to create formulas in Crytsal Reports.

Thank you.
Regards
Manish :smiley:

cr_manish :india: (BOB member since 2009-07-30)

3

Not sure what your trying to say here, you can`t use If Then Else to create formulae in Crystal, you use the formula editor.

Anyway, back to the question. No you can`t create a formula with a Where clause as such, however, you can create a formula which you then use in the record selection formula which then becomes part of the Where clause in the SQL statement. Bear in mind any Crystal style functionality in the formula will force record filtering to happen client side.

ABILtd :uk: (BOB member since 2006-02-08)