COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: qvixote on 06 May 2016 09:42:06 AM

Title: "Freeze panes" in cross table
Post by: qvixote on 06 May 2016 09:42:06 AM
Hello!

I wonder if someone has implemented something like the "freeze panes" functionality of MS Excel, to keep headers and first columns of a cross table visible while scrolling vertical and horizontal way. I have a report with a cross table with many columns and rows, so when users view data, it would be easier if they could keep always in sight the headers and first columns.

Thanks.
Title: Re: "Freeze panes" in cross table
Post by: MFGF on 06 May 2016 09:49:13 AM
Quote from: qvixote on 06 May 2016 09:42:06 AM
Hello!

I wonder if someone has implemented something like the "freeze panes" functionality of MS Excel, to keep headers and first columns of a cross table visible while scrolling vertical and horizontal way. I have a report with a cross table with many columns and rows, so when users view data, it would be easier if they could keep always in sight the headers and first columns.

Thanks.

Does the post below help?

http://www.cognoise.com/index.php/topic,27165.msg87012.html#msg87012

MF.
Title: Re: "Freeze panes" in cross table
Post by: qvixote on 06 May 2016 10:05:27 AM
Wow! It was implemented already! Right click and the option appear. Many thanks.
Title: Re: "Freeze panes" in cross table
Post by: cognosworkx on 24 Sep 2018 08:41:25 AM
Hey all,

two years were gone now, and the same problem occurs again on our CA11.0.10.

We need to freeze both the first column as well as the first row to allow scrolling without loosing the context. The solution provided in the link above does not work in the report (Full Interactivity off, non-active report).

Is there another hackaround known yet?

Thank you for your help! :-)