Multiple fields for one parameter

[LMRollins]

Here is the scenario:

I have 12 fields (lot1, lot2, lot3,etc)in a report that any one or more can have the same lot number in it per record. I created a parameter called ?mixlot. In select expert, I need to be able to take each of the twelve fields and if any of them enter the parameter ?mixlot, the record will show. This is how my formula looks:

lot1 = ?mixlot or lot2 = ?mixlot or lot3 = ?mixlot (and on until lot12)

My problem is that when I do this, it only seems to consider the first 3 statements and then quits and I don't get all the records I need. Anybody have any suggestions?

 

[dgillz]

Try this formula:

{?Mixlot} in [{lot1},{lot2},{lot3}.....{lot12}]



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

Either should work, and although dgillz appears to be more elegant, it will not pass the SQL to the database.

I just tried it with 6 different fields and it worked fine. Your problem may be that you malformed the record selection formula, or perhaps you need to patch it.

Select database->Show SQL Query to see what is being passed to the database, I think that you'll find the proper solution is by using your methodology, but you need to test how Crystal is interpreting it.

And rather than post what your formula looks like, consider posting the actual formula.

-k