2 Replies Latest reply on Dec 9, 2013 8:54 PM by JMcG

    display the second report as modalform and filter with primary key value of first report when you click on first report column link

    956152

      Hi All,

       

      I have two reports.

      1. order report

      2. order detail report

       

      when you click on the order report column it display the order detail report as a modal form.

       

      i was done below steps.

       

      1. In page header i was written the below code

       

      <link rel="stylesheet" href = "http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/themes/

      redmond/jquery-ui.css" type="text/css" />

      <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.js"> </script>

      <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/jquery-ui.js"> </script>

      <script type="text/javascript">

      $( function() {

      $('#ModalForm1').dialog(

      {

       

       

      autoOpen : false ,

      width :470,

      height: 500,

      resize :false,

       

       

       

       

      });

      });

      function openForm1()

      {

      $('#ModalForm1').dialog('open');

      }

      function closeForm()

      {

      $('#ModalForm1 input[type="text"]').val('');

      $('#ModalForm1').dialog('close');

      }

      </script>

       

      2. order report.

      3. order detail report

       

         select * from order_details where order_id = p_order_id;

       

      region header

       

      <div id="ModalForm1" title="Ordered Items" style="display:none">

      <p class="msg"></p>

       

      footer

       

      </div>

       

      4. created the hidden item in order detail report.

      5. in order report column attributes i was given link like below.

       

      javascript:$s('p_order_id','#order_id#');openForm1();

       

      when i click on the order report column link it passing the row primary key value to hiddent and open the report as modal form. however it is not filter the report with hidden item. it showing the no data found.

       

      problem is hidden item value is not submitting. once we submit that value it showing the 2nd report with filter data.

       

       

      can any help me to achieve above requirement.

       

       

       

      apex: 4.2

      oracle 11g

       

      Regards,

      Vijay.