If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

small question

Started by johny.cbi, 14 May 2008 09:22:07 AM

Previous topic - Next topic

johny.cbi

is it possible to do freezing for cross tab reports ?

only for columns

Thanks for the reply

blom0344

You mean like the Excel function where you can immobilize certain columns and scroll through the remainder?

johny.cbi

Yes, you are there ,  I've a cross Tab and I want make freeze for columns

I've a column Year and I gave the filter for the year ( [Year]>=extract(year,_add_years({sysdate},-2)) )

in support.cognos.com there is video for 'How to freeze a column in report studio'

that video doesnt support to my requirement

Thanks for any ideas

blom0344

The filter you mention should display only columns where year = 2006,2007,2008 regardless of other years present or the existence of colums for those 3 years.
Where does the 'freezing' come in to the story? 
In other words, the report would show 0 / 1 / 2 / 3 columns depending on your data..