COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Ann on 27 Feb 2012 12:20:49 AM

Title: render prompts based on userID
Post by: Ann on 27 Feb 2012 12:20:49 AM
Hi Guys,

I have  a requirement as below:

I wanted to render prompts based on userID. So I created a variable with definition:
CASE #sq($account.personalInfo.userName)# 
WHEN 'AAA' THEN 1
ELSE 0
END

I kept two prompts, rendered on the above variable. But now when i try to run the report, I see both the prompts displayed. :(

Any clue?
Title: Re: render prompts based on userID
Post by: absriram on 02 Mar 2012 09:03:03 PM
Try conditional block and set the "Box Type" property to 'None'.

Sriram.
http://www.cognosonsteroids.com (http://www.cognosonsteroids.com)