Skip to Main Content

Scroll classic report on APEX 4.1 (Freeze Panes)

There is many great posts in OTN forum how create scrolling classic report (freeze panes). Andy have post one example here. Thanks to Andy I did manage create this sample application using jQuery and dynamic action.

You need have EMP table in schema where you install this sample.

See working example.

Comments

  • Nivetha 23-MAY-16 12.52.26.000000 PM

    Hi ,

    Can you please tell me how to implement this in Tabular Form in APEX5, Universal Theme

  • Jari Laine 24-OCT-14 06.39.54.000000 AM

    Hi Richard,

    Could you please create example about problem to apex.oracle.com?

    Regards,
    Jari

  • Richard Legge 23-OCT-14 06.12.57.000000 AM

    Hi Jari,

    Im trying to use this feature for my report. Im running 4.2.4 with Theme 26.

    Ive amended my template, and can get the report to scroll with a vertical scroll-bar etc.

    However, I cannot freeze the column headers. They scroll with the report.

    The issue is the difference between the template that you are using, and the ones for theme 26..

    For example. your report template is as follows:

    <table class="uReportContainer" summary="" #REPORT_ATTRIBUTES# id="report_#REGION_STATIC_ID#">#TOP_PAGINATION#

    <tr><td><div id="#REGION_STATIC_ID#_top">

    <table summary="" class="report-standard"></table>

    </div></td></tr>

    <tr><td><div id="#REGION_STATIC_ID#_bottom">

    <table summary="" class="report-standard">

    and the template for theme 26 is as follows:

    <table class="uReportContainer" #REPORT_ATTRIBUTES# id="report_#REGION_STATIC_ID#" summary="">

    <tr><td><div id="#REGION_STATIC_ID#_top">

    <tbody class="uReportBody">

    <tr><td><div id="#REGION_STATIC_ID#_bottom">

    <table summary="#REGION_TITLE#" class="uReport uReportStandard">

    Ive tried moving the tags for #REGION_STATIC_ID#_top around, and tried using different classes, but cannot get the header to stay fixed.

    Could you please offer any advice on how to fix the headers with this theme / template?

    Kind Regards

    Richard

  • Jari Laine 28-MAR-14 07.49.10.000000 PM

    Hi Steven,

    Create report template where is same HTML structure as in sample application. But keep your theme css classes.
    Copy JavaScript from sample application to your page.

    I guess, this do not work correctly when you add rows to tabular form. Never tested with tabular form.

    Regards,
    Jari

  • Steven 28-MAR-14 06.17.11.000000 PM

    Does this work with tabular forms?

    I download the application and uploaded it into my workspace. Created a new template based off of the Horz/Vert Scroll template. And also made the Set Scroll DA but it doesn't seem to work correctly.

    Any Suggestions?

    Workspace: xxx

    Username: xxx

    Password: xxx

    Application: xxx

    Page: Tabular Form

    Thanks

    Steven

  • Jari Laine 23-JAN-14 03.56.29.000000 AM

    Hi Tony,

    I have not never really try create fixed headers/columns to IR. Sorry.

    Regards,
    Jari

  • tony miller 22-JAN-14 07.29.51.000000 PM

    Looked at it but current customer has issues with it being a Pay to use plugin from a Non-US country..

    Do you have any thoughts on how it might be done?

  • Jari Laine 22-JAN-14 06.49.37.000000 PM

    Hi Tony,

    Check Matt Nolan IR Plugin Package.

    Regards,
    Jari
     

  • tony miller 22-JAN-14 05.39.09.000000 PM

    Great example.. Do you know of any similar method being done with Interactive Reports?

  • Jari Laine 18-MAY-13 11.42.56.000000 AM

    Hi Andy,

    Thanks for sharing this.

    Regards,
    Jari