Oracle APEX - Interactive Report - Scrollbars on Top
I have been came across an interested requirement ( which is very valid ) to add scrollbars on the top of the regions! I have seen many times when you want to scroll right to see further data of first few records, you will scroll vertically to get to the horizontal scroll-bars. And then you do horizontal scroll and then vertical scroll to go top of the region. Aren't you ??? :-)
So, to ease the user interaction with IR - we should have a scrolling option somewhere on the top of the region ? - For Sure
So, how can we add scrollbars on top of the report for an Interactive Report ?
By default IR Fix the column headers to the page. This setting gives us an opportunity to add scroll-bars just below the column header as well.
Just by adding following CSS line you should get a beautiful scroll-bars just below you header and it works really great as well.
#MYIR .t-fht-thead{
overflow: auto !important;
}
I am also trying to find a way to add same functionality for Classic Report and I will let you all know once I figure that out.
Hope this helps!
Regards,
Jaydip Bosamiya
jbosamiya@gmail.com
Hi, in which section I must insert the code you provided?
ReplyDeleteHello, you should first give static ID ("MYIR") to your IR region and insert the css code in page header Inline CSS section or in theme roller. You may ignore the Static ID if you want all your IR on that page to consider with header scrolling. If you want this to implement across your application, you should add this to theme-roller without ID selector.
DeleteThanks, I have tried and working fine.
DeleteHey, is it also possible for the interactive grid?
ReplyDeleteYes, it is possible using following CSS. I have also updated the demo link with IG example.
Delete#MYIG .a-GV-w-hdr{
overflow: auto !important;
}
Thx. It woks fine :)
DeleteThe Scrollbars are not visible at the top in IG. Can you please check.
DeleteThanks. Its working fine.
ReplyDeleteThanks
ReplyDeleteCan you suggest how horizontal scrollbars that appear at the bottom of reports be made floating?
Very nice!
ReplyDeleteHello Jaydip,
ReplyDeleteBy this CSS scroll bar has added at top, But when we scroll bit down and then use the top scroll bar to move horizontally, It moves data only not the heading, Please help us.
THanks
Hi
DeleteYes, I noticed the same. If we scroll down and then try to slide the scroll bar, it removes the page header. Can you pleas assist?
OK, Please re-create issue on apex.oracle.com and send details, please.
DeleteMany Thanks for this code. Our users have been looking for this feature for a while.
ReplyDeleteThanks
DeleteIs it possible to make the top header sticky when i scroll down my report?
ReplyDeleteCan i make the scrollbar sticky in any way? So that when i go down it follows
ReplyDeletePlease refer https://apex.oracle.com/pls/apex/f?p=apexbyg:sticky_region on how to make region sticky.
DeleteHi, did you also find out how to add this scrollbar at top for the classic report?
ReplyDelete