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

Control static choices in a value prompt

Started by kravguy, 26 Jul 2012 10:10:57 AM

Previous topic - Next topic

kravguy

In Report Studio, can you control the static choices that show in a value prompt based on a data item value in one of the report queries?  For example if my sales rep is a "director" or above they will see "a", "b", "c", "d" in the value prompt else they will only see "a" and "b"? 

rockytopmark

NO, but you can have 2 Prompt Controls, 1 with choices A, B, C, D (PC1) and other with just A and B (PC2).
Then use a condition that checks the user's position level, for use as a Render Variable on the Prompt controls to display the correct 1, and only 1.

Example;
If Position Level Dir or above, Render PC1.
If Position Level < Dir , Render PC2.