Larry Rungren
asked on
Crystal Record selection
here is the record selection formula I have:
({RegistrationFeeControl.p roduct_beg in_date} >= {?begindate}
and
{RegistrationFeeControl.pr oduct_begi n_date} <= {?enddate})
and
if {?atty} = '' then true else {RegistrationFeeControl.pr ogatty} = {?atty}
and
if {?feeschedule} = '' then true else {RegistrationFeeControl.pr oductfeeco de} = {?feeschedule}
and
if {?practicearea} = '' then true else {RegistrationFeeControl.pr actice_are a} = {?practicearea}
If I only select by date range = OK
If I enter any other parameter, the record select does not filter on the value at all, only on the dates?
({RegistrationFeeControl.p
and
{RegistrationFeeControl.pr
and
if {?atty} = '' then true else {RegistrationFeeControl.pr
and
if {?feeschedule} = '' then true else {RegistrationFeeControl.pr
and
if {?practicearea} = '' then true else {RegistrationFeeControl.pr
If I only select by date range = OK
If I enter any other parameter, the record select does not filter on the value at all, only on the dates?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER