Muliple entries in a prompt

[insurancereports]

Hello everyone,

I have used prompts in reports before but with only one entry per prompt.
For example, there is a prompt which asks for one account number. However, I want to create a prompt which will accept multiple account numbers and give back all the information pertaining to the multiple accounts. How can this be done? Any ideas?

thank you
the Insurance analyst

 

[griffindm]

Multi-selection prompts can only be used with prompts other than the "type-in" option. Use the prompt values in an IN comparison, as in

location IN (?getlocation?) ...

You can only sustain a multi-selection prompt by making sure that it is ONLY used with the IN operator. If you use it a second time with an equality, it will only allow one selection in the prompt.

Hope this helps,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[insurancereports]

Thank you Dave.