Posts

Showing posts from April, 2013

Freeze panes in BO Webi report like Excel

Image
Since the design of my first BO report a need kept coming up. The need for freeze panes. When there is a table that doesn't fit in the screen and you start scrolling, the moment the headers disappear you lose track of your data and start scrolling up and down, left and right again and again to see those headers. Well here it is what you need to do to add freeze pane capabilities to your report. For this example we have the crosstab table of the screenshots below: Headers disappeared The logic is quite simple. With the help of javascript we are going to move headers accordingly to the user's scrolling so as the user thinks the headers are pinned to the screen while the body of the table is moving. The problem is that if we see the structure of the crosstab it is actually an html table which means that we can not move header cells independently from body cells. HTML structure of the crosstab So we have to break the crosstab down to three independent