Formula needed for parameter

[Jonesxx]

Hi


I’m using Crystal 8.5 and I have created a parameter called '{?!Sales}=' so that users can have a prompt to either select sales which are over £2000 or sales which are under £2000. The table name is SALES the column name is INCOME.

I would also like the users to be able to select sales from both categories e.g. where sales are under £2000 as well as over £2000. However I do not know the correct syntax. The formula I have used is as follows:


(if ( {SALES.INCOME}) <= '2000' then {?!Sales}= '2000>='
else {?!Sales} = '2000<=')

Please help

Thanks v m

 

[dgillz]

Add another valid value of the parameter called 'ALL'. Then place the following in your record selection formula.

if {?Sales}='ALL' then true else
if {?Sales}='<2000' then {Sales.Income}<2000 else
if {?Sales}='>=2000' then{Sales.Income}>=2000

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra