COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 06 Mar 2014 08:37:31 AM

Title: How to fix the columns of the report while scrolling,[SOLVED]
Post by: inu on 06 Mar 2014 08:37:31 AM
HI
I have a report having 25000 records scrollable. but while i go down to the records , even columns(header part of the records) doesnot stay . But i want to fix the columns for looking , what records associated to which column without scrolling towards the top position.
Is it possible or not.
Please rectify it.

Thanks
Inam
Title: Re: How to fix the columns of the report while scrolling
Post by: MFGF on 06 Mar 2014 09:01:27 AM
Hi,

Are you referring to freezing column headings in a list, or freezing row/column/home cell headings in a crosstab?

If so, the following document shows you how you can do this:

http://www.ibm.com/developerworks/library/ba-pp-infrastructure-cognos_specific-page641/

I tried it only this morning so I can confirm it works when rendering as HTML and using IE

Cheers!

MF.
Title: Re: How to fix the columns of the report while scrolling,[SOLVED]
Post by: navissar on 07 Mar 2014 04:34:31 PM
That's a very good method, if you don't happen to care a lot about compatibility and your server's stability...
CSS dynamic properties (AKA Expressions) are A. Deprecated in modern browsers; and B. causing errors to be written in Cognos' logs. Avoid these.
I'm labouring on a solution these days (There are some bumps along the way - it's a difficult piece of HTML), but in the meantime the best way to do this without running into these issues is the hard way: Create a table with the same number of columns as your list. Set your list column size to be fix. Set the table column size to be the same fixed value. Apply list header style on table. Drag the text items from list header columns to table. Hide list column headers. Place list in block with scrolling enabled.