is it possible to do freezing for cross tab reports ?
only for columns
Thanks for the reply
You mean like the Excel function where you can immobilize certain columns and scroll through the remainder?
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
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..