COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: RKMI on 15 Nov 2012 02:00:46 PM

Title: Dynamic Object Rendering
Post by: RKMI on 15 Nov 2012 02:00:46 PM
Hi,

Objective: Render page 1 if user 1 is running the report render page 2 if all other users.

Here is what I have tried to use marco in conditional variable if ((#sq($account.personalInfo.userName)#) = 'user1') then '1' else '2'. Added the string variable '1' for page 1 and '2' for page 2.

Please don't point me to data level security since its more to do with rendering based on user.

Thanks,
RK

Title: Re: Dynamic Object Rendering
Post by: Lynn on 16 Nov 2012 08:10:42 AM
Create two boolean variables. One should resolve to true if the user is user1 and would be the render variable you specify for page1.

The other boolean should resolve to true if NOT user1 and would be the render variable you specify for page2.