Hi,

When creating a parameter in InfoAssist, you have the ability to either make it a textbox (static) or a listbox (dynamic)
--> How can a user choose multiple values in a static parameter (textbox)?

Example: report prompting for list of terminals, but without using a listbox as that would result in way too many values...

So far, each time I try this, I get a generated SQL with TERMINAL = 'a,b,c' instead of TERMINAL IN ('a','b','c')
Note: scope of the question is InfoAssist - not DevStudio

Regards,
Peter

This message has been edited. Last edited by: Kerry,

Hi Peter,

From our technicals: There is a New Feature Request addressing this issue.

Workarounds:

Only for a text field:

I was able to make the prompt work in the following manner:

1 - Create a filter, Open ==> Simple.
2 - Select Prompt menu item and select ==> Prompt using text input(Simple).
3 - Run the report and enter the following in the text box:
ENGLAND' OR 'JAPAN

Note you have to leave out the first and last single quote. This is not a pretty workaround.

Or another account added a filter multiple times so that he had three prompts for the account number for example be careful to have unique parameter names.

Cheers,

Kerry