COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pooja on 16 Oct 2008 11:16:39 AM

Title: hiding column
Post by: pooja on 16 Oct 2008 11:16:39 AM
I am new in this forum and new in cognos

I have table with threee column and threee rows
I need to hide/show middle column with header.

can anybody suggest some tips with some description

thank you very much
pooja
Title: Re: hiding column
Post by: pooja on 16 Oct 2008 12:18:55 PM
anyone giving me some suggestions

pj
Title: Re: hiding column
Post by: jahnavi on 17 Oct 2008 07:03:06 AM
Hi Pooja,

Do the conditional formatting for the middle column. Then you can acheive that
Title: Re: hiding column
Post by: jahnavi on 19 Oct 2008 10:32:44 PM
Hi Pooja,

I just saw your mail. Yes here are the steps to solve the solution

write the condition you want there and then set the box type to none

or use the condition block for this

Title: Re: hiding column
Post by: pooja on 21 Oct 2008 11:05:28 AM
I have been trying to use conditional block.Still I am not able to usse.
I have  to show and hide the word onsome condition.
Title: Re: hiding column
Post by: elisha on 21 Oct 2008 03:09:43 PM
Could you please give your requirement?
Like for what conditions you want  hide and for what conditions you want to display the row?

Thanks - Elsiha
Title: Re: hiding column
Post by: Suraj on 22 Oct 2008 05:52:28 PM
jahnavi  has posted the answer above.
Box type = none hides the column.
Title: Re: hiding column
Post by: SSN on 23 Oct 2008 12:27:01 AM
Hi,
use below steps to hide a column.

if you want to give option to user to hide or unhide then follow below steps

1.Created a Prompt page
2.Drag Value Prompt> give name for that parameter HIDEPARAM > Click Next> Unchech  Parameterized Filter option and >Click Finish
3.click on value Prompt box in Prompt page> in Property Pane click on Static Choises.
4.Select "New Boolean Variable" for Variabls Drop down
5.Create a boolean variable and write an expression as ParamDisplayvalue('HIDEPARAM')='HIDE' and click OK.
6.Create use and Display Vale using add button as HIDE(both use and Display) and DON'THIDE
(both use and Display)
7.go to report page and select column + column header
8.Go to conditional Explorer and select yes under created variable(Green color appears on the explorer bar.) 
9.in the property pane on lefthand side click and select Style Variable and Click on Box Type and select none.

Run the report

Hope this will be helpful..

If you wnat to hide based on any condition,then follow from step 4.write your condition instead of expression in step 5.

Cheers..
SSN