Oracle APEX - Interactive Report - Scrollbars on Top

By
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

Comments

  1. Fabrizio Delli PriscoliDecember 6, 2019 at 12:26 PM

    Hi, in which section I must insert the code you provided?

    ReplyDelete
    Replies
    1. Jaydip BosamiyaDecember 6, 2019 at 12:34 PM

      Hello, 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.

      Delete
    2. Fabrizio Delli PriscoliDecember 6, 2019 at 1:02 PM

      Thanks, I have tried and working fine.

      Delete
  2. TimoDecember 6, 2019 at 1:29 PM

    Hey, is it also possible for the interactive grid?

    ReplyDelete
    Replies
    1. Jaydip BosamiyaDecember 7, 2019 at 3:38 PM

      Yes, it is possible using following CSS. I have also updated the demo link with IG example.

      #MYIG .a-GV-w-hdr{
      overflow: auto !important;
      }

      Delete
    2. TimoJanuary 21, 2020 at 12:01 PM

      Thx. It woks fine :)

      Delete
    3. AnonymousApril 29, 2020 at 7:54 PM

      The Scrollbars are not visible at the top in IG. Can you please check.

      Delete
  3. UnknownDecember 13, 2019 at 2:43 PM

    Thanks. Its working fine.

    ReplyDelete
  4. AnonymousJanuary 24, 2020 at 12:54 PM

    Thanks
    Can you suggest how horizontal scrollbars that appear at the bottom of reports be made floating?

    ReplyDelete
  5. Andrew WoodwardMarch 17, 2020 at 10:13 PM

    Very nice!

    ReplyDelete
  6. Hardik PatelMarch 27, 2020 at 4:03 PM

    Hello Jaydip,

    By 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

    ReplyDelete
    Replies
    1. SatyaAugust 24, 2020 at 10:03 PM

      Hi
      Yes, 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?

      Delete
    2. Jaydip BosamiyaAugust 25, 2020 at 9:29 PM

      OK, Please re-create issue on apex.oracle.com and send details, please.

      Delete
  7. AnonymousSeptember 9, 2020 at 10:39 AM

    Many Thanks for this code. Our users have been looking for this feature for a while.

    ReplyDelete
  8. AnonymousSeptember 11, 2020 at 2:21 PM

    Is it possible to make the top header sticky when i scroll down my report?

    ReplyDelete
  9. AnonymousSeptember 11, 2020 at 3:22 PM

    Can i make the scrollbar sticky in any way? So that when i go down it follows

    ReplyDelete
    Replies
    1. Jaydip BosamiyaSeptember 13, 2020 at 11:20 AM

      Please refer https://apex.oracle.com/pls/apex/f?p=apexbyg:sticky_region on how to make region sticky.

      Delete
  10. UnknownSeptember 22, 2020 at 3:54 AM

    Hi, did you also find out how to add this scrollbar at top for the classic report?

    ReplyDelete

Post a Comment

My photo
Jaydip Bosamiya
I am Oracle APEX Consultant, Blogger and Integrator. All-rounder in building small, medium and enterprise applications. Extensive knowledge in various area of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)

Popular posts from this blog

How to create your own customized nested report regions using jQuery

By
Image
Here is how you can create cool nested reports in Oracle APEX and jQuery, which looks like below: For this example, I have used DEPT & EMP example where as a nested report it will show all the child records of employee under department record. To start with, first create a new classic report region with query like " select * from dept ". Add a new derived column of type = Link to that report and set following attributes: Link: javascript: void(0); Link Text: <i class="fa fa-users" alt="Employees" title="Employees"></i> Link Attribute: class="viewEmp" data-deptno="#DEPTNO#" Add new page item to hold deptno value and call it PX_DEPTNO Create new classic report region (this will be your nested region) and set query like " select * from emp where deptno = :PX_DEPTNO " and set following attributes: Static ID:  EMPLOYEES Custom Attributes:  style="display: none" Page Items t...
Read more

Make your RESTful APIs Secured with OAuth2 - Basic, Simple and Easy Steps

By
Its been a while since my previous article. So, here is my first blog post of 2020. Oracle APEX has an out-of-box and declarative support to create RESTful Web Services using ORDS. Within no-time, you can build and publish your RESTful APIs. Use of ORDS has gradually increased with common standard across different technology strongly adopted via RESTful Web Services and JSON formatted input/output. With the flexibility of data sharing across the technology or within application, we must also think of how secure my RESTful APIs are. We do believe in strong security of our applications using Authentication and Authorization. But, many times we miss the level of security we should implement in our RESTful APIs. So, here is the very simple and basic steps to secure your ORDS RESTful APIs using OAuth2: We will use a default oracle.example.hr web service module to add OAuth2 for this blog. Navigate to SQL Workshop > RESTful Services. From the left side of tree - click on "Ro...
Read more