This discussion is archived
1 2 3 Previous Next 40 Replies Latest reply: Nov 3, 2011 9:40 PM by Tony F. RSS

Freeze Pane in Oracle Apex3.2

835027 Newbie
Currently Being Moderated
Hi,

Please help me out to implement Freeze Pane in Oracle Apex 3.2

Thanks,
Dhanalakshmi.
  • 1. Re: Freeze Pane in Oracle Apex3.2
    ATD Guru
    Currently Being Moderated
    Hi,

    If you mean that you want to freeze the headings on a report, have a look at: Does anyone know how to freeze column headings?

    Otherwise, what "pane" do you want to freeze?
  • 2. Re: Freeze Pane in Oracle Apex3.2
    835027 Newbie
    Currently Being Moderated
    Hi,
    Thanks for your reply..

    I am expecting the freeze panes with first column should be fixed while scrolling from right to left.

    Thanks,
    Dhanalakshmi
  • 3. Re: Freeze Pane in Oracle Apex3.2
    ATD Guru
    Currently Being Moderated
    OK - you want "Horizontal Scrolling" - see: horizontal bar Scroolling.
  • 4. Re: Freeze Pane in Oracle Apex3.2
    835027 Newbie
    Currently Being Moderated
    Hi,

    Sorry for the unneccessary questions asking you...

    The template creatiion also not clearly explained.
    and
    where do i paste the jave script given in the form thread
    horizontal bar Scroolling.

    Please help me..

    Thanks,
    Dhana
  • 5. Re: Freeze Pane in Oracle Apex3.2
    ATD Guru
    Currently Being Moderated
    Hi Dhana,

    Try the other link: Re: Horizontal scrolling report

    That describes the report template settings and where the script needs to be

    Andy
  • 6. Re: Freeze Pane in Oracle Apex3.2
    ATD Guru
    Currently Being Moderated
    Hi,

    Just to be clear for you, create a new Report Template using the following settings:

    Before Rows:
    <style type="text/css">
    #table1 th {white-space: nowrap}
    #table1 td {white-space: nowrap}
    #table2 th {white-space: nowrap}
    #table2 td {white-space: nowrap}
    </style>
    <table cellpadding="0" cellspacing="0" summary="" style="padding:0px; border-collapse:collapse;">#TOP_PAGINATION#
    <tr><td>
      <tr>
        <td style="vertical-align:top; background-color:#EFEFEF; padding:0px; border:1px solid darkgray;">
          <div id="d1" style="background-color:white; margin:0px; border:0px; padding:0px;">
          </div>
        </td>
        <td style="vertical-align:top; padding:0px; border:1px solid darkgray;">
          <div id="d2" style="overflow-X:scroll; margin:0px; border:0px; padding:0px; border-right:1px solid darkgray;">
    <table cellpadding="0" border="0" cellspacing="0" summary="" class="t18Standard" id="table2">
    Column Heading Template:
    <th class="t18ReportHeader"#ALIGNMENT# id="#COLUMN_HEADER_NAME#">#COLUMN_HEADER#</th>
    Before Each Row:
    <tr #HIGHLIGHT_ROW#>
    Column Template 1:
    <td #ALIGNMENT# headers="#COLUMN_HEADER#" class="t18data">#COLUMN_VALUE#</td>
    After Each Row:
    </tr>
    After Rows:
          </div>
        </td>
      </tr>
    </table><div class="t18CVS">#EXTERNAL_LINK##CSV_LINK#</div></td></tr>#PAGINATION#</table>
    <script type="text/javascript">
    var d1 = document.getElementById("d1");
    var t2 = document.getElementById("table2");
    var t1 = t2.cloneNode(false);
    t1.style.width = "100%";
    t1.id = "table1";
    d1.appendChild(t1);
    var t2Rows = t2.rows;
    var k;
    var r;
    var c;
    for (k = 0; k < t2Rows.length; k++)
    {
     r = document.createElement("TR");
     t1.appendChild(r);
     c = t2Rows[k].cells[0].cloneNode(true);
     r.appendChild(c);
     t2Rows[k].deleteCell(0);
    }
    d1.innerHTML += "";
    </script>
    Next Page Template:
    <a href="#LINK#" class="t18pagination">#PAGINATION_NEXT# ></a>
    Previous Page Template:
    <a href="#LINK#" class="t18pagination"><#PAGINATION_PREVIOUS#</a>
    Next Set Template:
    <a href="#LINK#" class="t18pagination">#PAGINATION_NEXT_SET#>></a>
    Previous Set Template:
    <a href="#LINK#" class="t18pagination"><<#PAGINATION_PREVIOUS_SET#</a>
    Then update your report to include the following in the Region Header setting:
    <style type="text/css">
    #d1 {width:175px;}
    #d2 {width:400px;}
    </style>
    That is what is running on: http://apex.oracle.com/pls/otn/f?p=267:47

    Note that the above template is using Theme 18 - all "class" names are prefixed with "t18" - change this to your own theme (eg, if you are using Theme 12, change this to "t12" - or check with the Standard Report template for the "class" names you need)

    Andy
  • 7. Re: Freeze Pane in Oracle Apex3.2
    Tobias Arnhold Journeyer
    Currently Being Moderated
    Hi Andy,

    nice solution. I just added it to my blog. Work like that just needs to be mentioned. :)

    Cheers,
    Tobias
  • 8. Re: Freeze Pane in Oracle Apex3.2
    ATD Guru
    Currently Being Moderated
    :D

    That solution should work with any version of Apex. I think Jari is doing a plug-in for Apex 4.

    Andy

    ps - one of these days, I really must get myself a blog
  • 9. Re: Freeze Pane in Oracle Apex3.2
    835027 Newbie
    Currently Being Moderated
    Hi..

    Thanks a lot...

    Report got generated with Horizontal Scroll Bar ..


    But the datas are not correcly aligned...ie the firxed column row values are coming together irespective of remaionig
    rows.


    i.e

    col1 col2 col3
    val1
    ------
    val2 val1 val1
    ------
    val3 ------------------------------
    ------
    val4
    -----
    val5 val2 val2
    -----
    val6 ---------------------------------
    -----
    val3 val3

    --------------------------------------

    val4 val4

    ----------------------------------------

    val5 val5

    ----------------------------------------

    val6 vall 6


    Please advice me to correct this isse.

    thanks,
    dhana
  • 10. Re: Freeze Pane in Oracle Apex3.2
    Tobias Arnhold Journeyer
    Currently Being Moderated
    That would be a great plug-in.

    What a shame! The best forum writer doesn't have an own blog. :) Just write me a message so that I can link to your new blog as soon as it is online! :)

    Tobias
  • 11. Re: Freeze Pane in Oracle Apex3.2
    ATD Guru
    Currently Being Moderated
    Hi,

    Can you take a screenshot and upload it here: http://apex.oracle.com/pls/apex/f?p=267:11

    That way I can see exactly what may be happening

    Andy
  • 12. Re: Freeze Pane in Oracle Apex3.2
    ATD Guru
    Currently Being Moderated
    Not sure that I have time for a blog and answering forum threads ;)
  • 13. Re: Freeze Pane in Oracle Apex3.2
    vee Guru
    Currently Being Moderated
    I m surprised how u have time for anything else when you post answers for every other question here
    Is Andy really a Bot :P
  • 14. Re: Freeze Pane in Oracle Apex3.2
    ATD Guru
    Currently Being Moderated
    Sometimes I feel like one!
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points