If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Using Text Box Prompt values in a List

Started by Amir Vazquez, 13 Nov 2015 01:33:32 PM

Previous topic - Next topic

Amir Vazquez

Good day,
I have a question about prompts in Report Studio. I have a Text Box Prompt that I am entering some values. I then use these values to filter out the report (Easy). Now here is where it gets interesting. Not all of the values entered are valid, so I would like to show in a list all of the values entered and compared them with the ones returned.

So if 3 items got entered and only 2 came back. I want to show the following.
Input           Return
11-1111111   True
12-2222222   False
13-3333333   True

How can I use the values from a Text Box Prompt and display them in a list? I know they need to be in another Query and then join them together. Yet when I pass the values from the prompt they are in one full string.

Thanks in advanced,
Amir