Is there any possible way of passing an array to the select expert and parsing the values out and building a where clause? The problem I seem to be running into is that the user can basically select an undetermined number of parameters from a list box. I would like to take these values from the array and manipulate them so that I am not doing a large "IN" clause.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Question about Passing Array to Select Expert
- Thread starter jhein
- Start date
synapsevampire
Programmer
I'll be surprised to learn that Crystal is constructing an IN clause, if you check the pass through, it's probably using an OR.
I don't have CR 9 here to test with that, but CR 8.5 won't generate an IN if you have {table.field} = {?MyMultiParm}, it generates a series of OR statements.
Check the SQL (Database->Show SQL Query).
If you find otherwise, post your record selection formula, I'd like to see why Crystal screws that up.
-k
I don't have CR 9 here to test with that, but CR 8.5 won't generate an IN if you have {table.field} = {?MyMultiParm}, it generates a series of OR statements.
Check the SQL (Database->Show SQL Query).
If you find otherwise, post your record selection formula, I'd like to see why Crystal screws that up.
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question
- Locked
- Question