Search results for query: *

Ok it is running correctly now . Thank you so much for your help and being patient with my ignorance. Much appreciated.

Users with be searching manually. Here is the record selection formula I have in place: {?ItemNumber} <> "All" and {Item_Detail.PRODUCT} = {?ItemNumber} or {?ItemNumber} = "All" and {?Serial} <> "All" and {Item_Detail.SER} = {?Serial} or {?Serial} = "All" and{?OrderNo} <> "All" and...

Also when i prompt now for new parameters and I just enter a Serial number to search by it only populates the serial number data but the other data fields are blank.

I am having trouble still. I added the OrderNo parameter and in the Select Expert I added the formula you gave me. Forgive me but I don't understand about where I am supposed to add the "All" option?

Thank you I will give it a shot and see if I can get it to work. Thank you again for you help . I will let you know how it turns out.

Sorry Crystal 10

I have a report that uses 3 parameters to search by Order Number, Serial, and Item Number. The set up requires that the query fields all have a full value in them or a "*" in order for any data to be pulled. I need to set up a formula that will allow the user to run a partial query in one field...