COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Kid_in_Cognos on 02 Jun 2016 02:37:18 AM

Title: Hide/Display columns
Post by: Kid_in_Cognos on 02 Jun 2016 02:37:18 AM
Hi

I want to hide or display coulmns based on the selection in the prompt  Yes/No.

I can able to achieve using the conditional block. But is it possible to do it using case stmt?. As I have to hide or display columns based on three prompts.


For ex:

There are 3 prompts Cert Num, cliam_stats, SRVROLE

1. If Cert_Num is Yes then display col A .Else display col B

2. If cliam_stats Yes then display col D .Else display col E

3. If SRVROLE Yes then display col F .Else display col G


Is this scenario can be achieved using case statement instead of conditional block? If so can you please let me know how to do it?

Thanks
Title: Re: Hide/Display columns
Post by: HalfBloodPrince on 02 Jun 2016 02:48:20 AM
you can use render /Style variable to achieve this
Title: Re: Hide/Display columns
Post by: Kid_in_Cognos on 02 Jun 2016 03:30:32 AM
Thanks Prince. Used Style variable successfully. :)