Multi-Select to Request Variable
665779Oct 17 2008 — edited Dec 10 2008
I'm trying to create a multi-select prompt and set it to a request variable. However, when i select multi-select, it takes away the ability to assign the users choices to either presentation/request variables.
This report calls a stored procedure with the given values from the prompts which populates a global Temporary Table and reads the results from that.
This works fine, however I want the user to be able to search based on many different id's, not just one.
I've noticed you can select edit-box, and assign this to request variables. So in theory, the user could manually type in the ids, separated by commas, and have the stored procedure deal with this. This is problematic for many obvious reasons.
Can anyone think of a better work around for this?