Unanswered: URGENT !!! Multiple Values in Parameter
The user is allowed to
select N distinct and discontiguous values from a list of available
values e.g. from a list of car models
[ ] Chrysler
[ ] Dodge
[ ] Buick
[ ] Toyota
[ ] Nissan
the user can select Buick and Nissan only, then receive a report about
just the requested models. The difficulty is that the user may choose
any number of data points, from 0 to the whole list, which doesn't fit
nicely into the traditional user parameter form that has
parameter1 = value1
parameter2 = value2
parameter3 = value3
and providing a fixed list of parameters will always impact flexibility
e.g. provide 10 parameters, each one based on the same list, and allow
the user to select up to 10 separate values - not much good for the user
who needs data on 11 cars (has to run the report twice and combine the
Thus the question about generating an array to hold N values.
Anyone know how to handle the situation ?
>There is only one field which needs to be searched for car models like
>Chrysler, Nissan ..etc.
So what difference does this make on any solution?
From my perspective some dynamic SQL would be one way to solve this.
WHERE MODEL = 'NISSAN'
OR MODEL = 'FORD'
OR MODEL = 'DODGE'
To create the SQL you'd use all the name/value pairs set to TRUE.
How else do you propose to create a single report
which is based upon 1-n user selections of models?