I thought to post this thread long time back during 22.214.171.124 version but just waited for 11g new release .5 and upcoming edition assuming Oracle might include this demanding features soon and still surprised there is no OOB feature included while we are in .6 now.
I know the couple of fellow bloggers already tried that and everybody could have different approach . So lets put what I had experimented in last year in .3 release which is still valid in .6 . And this approach and implementation still valid in 10g.
Its simple to have column header freeze adding some scripting with embedded content . I took a simple dimension and simple fact to create one Tabular report and one Pivot report in two different tab where I have applied same logic but just want to show that the feature still feasible in both view.
So lets see how it will look like after Tabular column freeze (I would rather say it is kind of floating column header attributes)
Now I have scrolled at the right pane and watch the year attributes. Now you can see that the column header retains.
Now see the implementation:
I have added Text and Embedded content in the dashboard page:
The text properties(HTML Markup checked): I can’t put it like text for your copy paste as the tag is restricted to use in wordpress and sorry for that 😦 Hence click on the image to get the detail view.
Embedded Content URL:
So I have created a simple tabular report with the above columns and saved it under my folder and referred that in the URL .
That’s it and you are done …
Now if you try to implement the same, you will see some alignment issue and in that case you need to adjust the Width and height and other parameters of HTML content to get the cropped column list . Note that in above implementation I just remove my title view from report .
Though the above design has a lot of other restrictions (Downloading , Column sort ) but there could be possible workaround for that. At-least you can get something which is better than nothing. 😀
Similar way I did it in Pivot view :
In this case my Embedded URL is different: (note the Viewname param at the end which only pull the compoundView2 which is my pivot table)
Refer this same URL under the HTML content defined in above image as Text HTML Markup properties.
Let the soul of the above approach rest in peace once Oracle implements this as OOB functionality in upcoming releases !!! 🙂
And we expect this to be sooner than later …. Catch you again ..till then ….