Forum Stats

  • 3,837,493 Users
  • 2,262,264 Discussions
  • 7,900,305 Comments

Discussions

Multi-Select to Request Variable

Hi,

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?

Thanks

Answers

This discussion has been closed.