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