Hiding columns

[shindhu]

Hi,

Any ideas for the following reqmt:

How do we dynamically hide the columns.i.e I have a prompt value for ProductNo: when the product no is 3000 chosen, i need to hide the column completley(including the
column header)

I tried by using the conditional formatting to achieve the same, but i could not able to hide the header though data is getting hidden

Will macros be of any use? if so pls suggest the solution

Thanks
Shindhu

 

[griffindm]

See thread401-840209

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com