Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Any Idea for classical Freezing columns

ReemaPuriMar 27 2015 — edited Mar 30 2015

I have tried so far :-

Reffered

Referr:-http://jaris.blogsite.org/apex/f?p=BLOG:READ:0::::ARTICLE:59900346164562

CREATED REPORT

SELECT

ENAME,

EMPNO,

APEX_ITEM.DATE_POPUP2(

        p_idx                       =>    1,

        p_value                     =>  NULL,

        p_date_format               =>    'DD-MON-RR',

        p_size                      =>    20,

        p_maxLength                 =>    2000,

        p_attributes                =>    NULL,

        p_item_id                   =>    'f01_'||ROWNUM,

        p_item_label                =>    'Label for f01_'||ROWNUM,

        p_default_value             =>    null,

        p_max_value                 =>    null,

        p_min_value                 =>    null,

        p_show_on                   =>    'button',

        p_number_of_months          =>    null,

        p_navigation_list_for       =>    'MONTH_AND_YEAR',

        p_year_range                =>    '1950:2050',

        p_validation_date           =>    null) "START_DATE"

FROM emp;

IMPORTED

jquery.htmldbHscroll-0.0.1.js

jquery.htmldbHscroll-0.0.1.min.js

iN STATIC FILES IN WORKSPACE OF APPLICATION

IN PAGE HTML HEADER

<script type="text/javascript" src="#IMAGE_PREFIX#PATH/app_page48.js"></script>

<script src="#WORKSPACE_IMAGES#jquery.htmldbHscroll-0.0.1.min.js" type="text/javascript">

</script>

USING standard report template  for the report

Theme -Blue Builder 2

Apex version 4.2.4

using pop up template for the page

header

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html lang="&BROWSER_LANGUAGE." xmlns:htmldb="http://htmldb.oracle.com">

<head>

<title>#TITLE#</title>

#APEX_CSS#

#TEMPLATE_CSS#

#THEME_CSS#

#PAGE_CSS#

#APEX_JAVASCRIPT#

#TEMPLATE_JAVASCRIPT#

#APPLICATION_JAVASCRIPT#

#PAGE_JAVASCRIPT#

#HEAD#

<link rel="stylesheet" href="#IMAGE_PREFIX#themes/theme_2/css/theme_4_0.css" type="text/css" />

  <!--[if IE]><link rel="stylesheet" href="#IMAGE_PREFIX#themes/theme_2/css/theme_4_0_ie.css" type="text/css" /><![endif]-->

  <!--[if IE 6]><link rel="stylesheet" href="#IMAGE_PREFIX#themes/theme_2/css/theme_4_0_ie6.css" type="text/css" /><![endif]-->

  <!--[if IE 7]><link rel="stylesheet" href="#IMAGE_PREFIX#themes/theme_2/css/theme_4_0_ie7.css" type="text/css" /><![endif]-->

</head>

<body #ONLOAD# class="popup-page">#FORM_OPEN#

Body :-

<table summary="" cellpadding="0" width="100%" cellspacing="0" border="0">

<tr>

<td width="100%" valign="top"><div class="t1messages">#SUCCESS_MESSAGE##NOTIFICATION_MESSAGE#</div>#BOX_BODY##REGION_POSITION_01##REGION_POSITION_02##REGION_POSITION_04##REGION_POSITION_05##REGION_POSITION_06##REGION_POSITION_07##REGION_POSITION_08#</td>

<td valign="top">#REGION_POSITION_03#<br /></td>

</tr>

</table>

footer

#FORM_CLOSE##DEVELOPER_TOOLBAR#

#GENERATED_CSS#

#GENERATED_JAVASCRIPT#

</body>

</html>

The problem is my datepicker is not clickable i am not getting calender by clicking on his image after using this jquery script for freezing columns

columns re freezing properly

I would appreciate if any other idea for classical report freezing column ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2015
Added on Mar 27 2015
3 comments
865 views