COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognosbuddy on 09 Jul 2015 04:05:07 PM

Title: How to select relevent crosstab from value prompt?
Post by: cognosbuddy on 09 Jul 2015 04:05:07 PM
Hi friends,

I have two types of crosstabs in my report sheet. Type-A has 2 crosstabs and similarly Type-B has another 2 cross tabs.

Now, I would like to have a value prompt and change between Type-A & Type-B. I do not want any calculations in the cross tab to change. I would only want the crosstabs to appear and disappear depending on the selection of the value prompt.

The value prompt should have the following two selections only: Type-A; Type-B. Thus making a required selection.

Could someone please help me with this request?

Thanks a lot.
Title: Re: How to select relevent crosstab from value prompt?
Post by: Gyana on 10 Jul 2015 12:14:47 AM
There are two approach : Using Style Variable ( Hiding the Crosstab) Or Render Variable (Rendering the Page)
Title: Re: How to select relevent crosstab from value prompt?
Post by: cognosbuddy on 10 Jul 2015 08:11:57 AM
Hi Sekhar,

Thank you for your reply. Could you please help me achieve this step-by-step?

Thank you
Title: Re: How to select relevent crosstab from value prompt?
Post by: MFGF on 10 Jul 2015 09:25:45 AM
Quote from: cognosbuddy on 10 Jul 2015 08:11:57 AM
Hi Sekhar,

Thank you for your reply. Could you please help me achieve this step-by-step?

Thank you

Have you looked in the Report Studio User Guide?

Here's a link to it: http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/ug_cr_rptstd.pdf

Take a look at the section entitled "Adding conditional rendering to a report" on page 386

MF.
Title: Re: How to select relevent crosstab from value prompt?
Post by: cognosbuddy on 14 Jul 2015 12:12:41 PM
Thank you very much MF.