selection formula 1

[Ravala]

I have three input parameters and record selection formula looked like this:
{ORDER_PROC_V.ACCOUNT_ID} = {?Account_ID} and
{ORDER_PROC_V.SHIP_DATE} >= {?FromDate} and
{ORDER_PROC_V.SHIP_DATE} < DateAdd("d", 1, {?ToDate})
It worked fine until I inserted control structure and changed formula on:
if {?Account_id} in [20,21] then
{ORDER_PROC_V.ACCOUNT_ID} = {?Account_ID} and
{ORDER_PROC_V.SHIP_DATE} >= {?FromDate} and
{ORDER_PROC_V.SHIP_DATE} < DateAdd("d", 1, {?ToDate}) and
{ORDER_PROC_V.ORDER_TYPE} in ["HQ", "REGULAR"]
else
{ORDER_PROC_V.ACCOUNT_ID} = {?Account_ID} and
{ORDER_PROC_V.SHIP_DATE} >= {?FromDate} and
{ORDER_PROC_V.SHIP_DATE} < DateAdd("d", 1, {?ToDate})

It runs forever. What couls be a problem?
Please help.Thanks.

 

[Madawc]

How are you linking the other records to {ORDER_PROC_V.ORDER_TYPE}? Try commenting it out, // in front, to check whether this is the source of the problem.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5.

Madawc Williams (East Anglia, UK)

 

[kskid]

Try this

(
{?Account_id} in [20,21] and
{ORDER_PROC_V.ACCOUNT_ID} = {?Account_ID} and
{ORDER_PROC_V.SHIP_DATE} in [{?FromDate} to {?ToDate}] and
{ORDER_PROC_V.ORDER_TYPE} in ["HQ", "REGULAR"]
)
or
(
not({?Account_id} in [20,21]) and
{ORDER_PROC_V.ACCOUNT_ID} = {?Account_ID} and
{ORDER_PROC_V.SHIP_DATE} in [{?FromDate} to {?ToDate}]
)