COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ajen7118 on 14 May 2015 03:20:06 PM

Title: ***Urgent***How to show each page individually
Post by: ajen7118 on 14 May 2015 03:20:06 PM
Hi all,

I have a prompt with 6 different display names such as A, B, C, D, E, F to show different data.

I created a 6 pages named page1, page2.... page 6.

There will be only 1 page to show each time when I choose the prompt and the other 5 pages need to be hid.

I checked online and tried some solutions. Noneof them seems to work for me.

I have tried created the Boolean variables below and apply the variable to page render variable.  However, all 6 pages still came out when I only chose one prompt.

ParamDisplayValue('A') IS NOT NULL
ParamDisplayValue('B') IS NOT NULL......

Could you please help? Thank you very much.




Title: Re: ***Urgent***How to show each page individually
Post by: bdbits on 14 May 2015 05:29:02 PM
ParamDisplayValue() is what the user sees, so you may want ParamValue('A') to inspect the actual value of the parameter. Also, the argument to these functions is the name of the prompt parameter. Are your prompt parameter names really 'A', 'B', 'C', etc.? I suspect you have a single parameter with a name like Parameter1 - the default - so your expression for each boolean is probably more like these expressions.
For bShowPageA: ParamValue('Parameter1') = 'A'
For bShowPageB: ParamValue('Parameter1') = 'B'
For bShowPageC: ParamValue('Parameter1') = 'C'
etc.

Hope that makes some sense and helps.
Title: Re: ***Urgent***How to show each page individually
Post by: ajen7118 on 14 May 2015 06:18:18 PM
Thank you very much for your reply.

My parameters are ('PROP', 'ADOPT', 'FINAL', 'FINALCHGT', 'CY_BUDG','CY_EST') stands for each timeperiod in my prompt page and
Display names are ('Recommend', 'Adopted', 'Final', 'FinalChange', 'Allowance', 'Estimate').

You meant I will need to create 6 variables to apply on each one.

For example, to show Page 1 (PROP=Recommend) --> bShowPage1: ParamValue('PROP') = 'Recommend'  --> the other pages wont show

For example, to show Page 2 (ADOPT=Adopted) --> bShowPage2: ParamValue('ADOPT') = 'Adopted'--> the other pages wont show
ETC.

thank you every much