Record Selection Formula is not working

[1cutedimple]

Hello,
I have a formula that is supposed to extract a certain Broker # based on a parameter date range. It's not working. Can you please tell me what is wrong with it? Thanks!

IF ({Crystal Report LookUp\Transaction Status.CAD Broker#<String>} = "18051") THEN

CDate({Crystal Report LookUp\Transaction Status.Creation Date<String>})
IN {?ReportFromDate} TO {?ReportToDate}
AND ({Crystal Report LookUp\Transaction Status.Status<String>} = "Complete")
AND ({Crystal Report LookUp\Transaction Status.TransactionInd<String>} = "CAD")

ELSE

CDate({Crystal Report LookUp\Transaction Status.Creation Date<String>})
IN {?ReportFromDate} TO {?ReportToDate}
AND ({Crystal Report LookUp\Transaction Status.Status<String>} = "Complete")
AND ({Crystal Report LookUp\Transaction Status.TransactionInd<String>} = "US")

 

[lbass]

If you are trying to select this particular broker with records during the time period with complete status and "transactionind" of either "US" or "CAD" then try a record selection formula of:

{Transaction Status.CAD Broker#} = "18051" and
CDate({Transaction Status.Creation Date}) in
{?ReportFromDate} to {?ReportToDate} and
{Status.Status} = "Complete" and
{Transaction Status.TransactionInd} in ["CAD","US"]

Otherwise, it might help to understand more specifically what you are trying to do.

-LB