I know this is an age old question.
I know there's an option now to right click and fix headers, but that messes with the formatting (afaik), and I'd like to have the scrollbars there when the report runs.
I know there's a trick with hiding the column headers and building a set of separate headers in a block above - but we know that sometimes makes for odd formatting when the screen is resized and the columns and headers get out of line.
My question is whether anyone has found a genuine workable solution for this problem?
Thanks.
Right. Yes. This is a bit of a pickle.
Generally speaking, there are three ways to achieve this.
1. Use JavaScript to change the location of the header on scroll. Disadvantage is that the header flickers, also on long lists the constant JSing might get your browser stuck.
2. Use a CSS dynamic expression. These work well, but they are not supported by modern browsers (deprecated) and also fill up the Cognos log with errors.
3. Duplicate the header row and make the list below static. This is actually what the IBM right click menu does.
Paul and I tries to tackle this thing several times, but never really got anywhere other than these 3 ways (Unless the awesome genius that Paul is managed to do something without me and without telling me about it). I'm using the built in IBM right click thingy with several clients and it seems fine, though I don't know what formatting you use. I suggest you try it, and make format corrections where necessary.