| select list of values from parameter form [message #557172] |
Sat, 09 June 2012 23:58  |
 |
7anona
Messages: 72
Registered: February 2012
|
Member |
|
|
Hello to all..
I am trying to select multiple values from a parameter form based on a select statement.
I created the parameter and write the select statement under list-of-value property
However what I want is to let users choose multiple values from the select statement not only one
value.
|
|
|
|
| Re: select list of values from parameter form [message #557177 is a reply to message #557172] |
Sun, 10 June 2012 03:02  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
As far as I can tell, you can't do that (or, at least I don't know how to do it).
However, here's a possible workaround: create a form (using Forms Builder). Its source should be a table you used in a report parameter (or, if this statement selects values from different tables, make data block's source a view or a FROM clause query.
Besides a value, create a checkbox for each of them: if it is checked, you'd use that value in a report. Once you're done, push a button (or do something similar) which will insert checked values into a table (you'd have to create it too).
The rest is easy - report would just look into that table and use these values in its WHERE clause.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
