Parameter Problem for addresses 1

[ziggs]

I'm using CR8 and I am accessing an Oracle DB, version 8i.

I have a crystal report that calls for three parameters for an address (digits, Street, and apartment). If I just use two parameters (digits and Street), I will get the correct returns for a report. However, when I add the third parameter field (apartment), I do not. For example, 428 Main St Apt4 and 428 Main St are two addresses in the DB. If I use the apartment prompt, I do no get the 428 Main St in my report but I do get 428 Main St Apt4. I have tried "converting null field values to default" with no luck.

Any idea on how I can set this up so that I can have the third prompt and get all the returns? [sig][/sig]

 

[kenhamady]

"Convert Null" happens after selection, so that will make the problem worse.

Try an If-Then in you selection formula:

( If {?AptPrompt} = "" then True else {?AptPrompt} = {Field})

[sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]