>Can anybody out there help?
>
>MSDN article Q156631 says quite clearly that the IN() filter condition doesn't work! Thats all very well but how do I do a parameterized view for a numbers of customer IDs when I don't know how many I will need to look for?
>
>Has anybody any good ideas of how to get round this one?
>
>Thanks in advance
>Jeremy
From a previous reply of mine:
I have had this problem where you can not parameterize a list of values for the IN or INLIST function. The problem is with character values where each has to be in quotes. You can not submit a character string like "3053", "3051", ..., "4152" . If you know you will never submit X number of items in the list, you could create X parameters in the IN.
IN (?Parm1, ..., ?ParmX)
Then if the user only select X-1 parameters, you would have to make parameter X some value that you must know does not exist. I have never found a way to parameterize a list with a variable number of parameters, at least for a permanent view.
You can build this successfully in SPT.
Mark McCasland
Midlothian, TX USA