Howto display a report with a fixed column and header

Written on Januar 28th, 2010 by Niels

As seen many times in Oracle Forms applications, the first column of a report is made “fixed” so the user can scroll horizontally through the columns without losing an eye on the first column. As we are currently migrating a Forms application to APEX, we had to find an alternative in APEX for this feature. Browsing through  the web, we found something called jQuery FixedTables. Having spend a couple of hours on it, we integrated it in one of our APEX demos on portal.mt-ag.com. We are currently evaluating to make a Dynamic Action Plugin out of it. If it works as expected, then we will publish it on our website. In the meantime, if you have equal challenges in your APEX project, feel free to drop me an email and I will send you the demo as a packaged application. It will save you the time I have spend on it. :)

Share
Filed under Allgemein Tags:

4 Comments to “Howto display a report with a fixed column and header”

  • Roel sagt:

    Very nice example! Can’t wait for the plugin!

    Keep up the good work.
    Roel

  • Bhavin Adhvaryu sagt:

    It is really good example.

    Looking forward to fixedheader plugin.

    Regards,
    Bhavin

  • Buzz Killington sagt:

    Looks great – I had tried this out too with a large tabular form, but found that for many columns and rows it sometimes took a while to render in certain browsers. There would be a noticeable screen jump while it re-wrote the HTML to fix the headers.

    But it is a pretty slick solution.

  • Niels sagt:

    @Buzz: if you hide the original report in a layer, the “screen jump” won’t occur.

Leave a Reply

(erforderlich)

(erforderlich)


SEO Powered by Platinum SEO from Techblissonline