[RESOLVED] Life, Death, and Parameters

[noobi]

Using CR 8.5
Reporting from SQL 2003

I am creating (trying to) a report that uses parameters to display technical data. Although there is this problem that i cant seem to shake. I have two fields that contain serial numbers that need to be queried. I can create a parameter that searches one table although i can't create one that searches both at the same time.
Is there a way i can reference both tables as one? Or any other suggestions that can make this query possible?
Let me know i require more detail..

Thanks for your time

[3omda]

Hi there,

You can just create the new parameter, say you call it Serial Number. in the report expert write:

{?Serial Number} like ({table1.serial_num} or {table2.serial_num})

[noobi]

Interesting enough i have tried that and i get the message that i need a boolean. BUT, thanks to your idea i tried this ...

{?sch} in ({iminvloc_sql.user_def_fld_2} & {iminvloc_sql.user_def_fld_3})

This works.. well kind of. This works if there arent any null fields.. So i'm making progress now i need to know how to query and allow null fields.

Any ideas?

Thanx abunch!

[jggtz]

You can try next Record Selection Formula

{?sch} = {iminvloc_sql.user_def_fld_2} Or {?sch} = {iminvloc_sql.user_def_fld_3}

And about Null fields You can check in
File / Report Options / Convert NULL Field Value to Default
so You don't need to test if the fields are null or not

[noobi]

This worked! Issue resolved!
Thank you very much 3omda & jggtz.