Prompt selection

[aa44]

I have prompt which has list of departments , when i publish on the web the user can able to select multiple departments at a time .Here i wnat to restrict to single selection is it possible ?

 

[griffindm]

Multiple picklist selections are possible when the filter uses an 'IN' clause. Replace this with an "=" operator and the user should only be able to select a single row in the picklist.

Hope this helps,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com

 

[aa44]

Thanks Dave , It's working fine .

 

[BeckyBoop]

I have a report I've posted to the web that uses the "in" prompt. However, when the report is posted, the prompt variables don't show up in the heading (as they do in Impromptu). Any suggestions?

Thanks,
Becky