Link Report to from/Report by java-script + HTML Expression

 

Step-1
=====

Create a IR report (Master Report).
SQL Query:
select 

      XLID AS ORG,

      REQ_HEADER_ID,

.

.

from Table_Name;

Select REQ_HEADER_ID column. 

HTML Expression:

<a href="javascript:void(0);" class="set-po" data-id="#REQ_HEADER_ID#">

  #REQ_HEADER_ID#

</a>

Step-2
=====

Create Apex Item. P22001_PR_HEADER_ID

Create a Classic report (Details Report).

SQL Query:
SELECT

     REQ_LINE_ID,

     REQ_HEADER_ID,

     .

     .

FROM TABLE_NAME

WHERE REQ_HEADER_ID = :P22001_PR_HEADER_ID

Page Items to Submit: P22001_PR_HEADER_ID

Template: Inline Dialog

CSS Classes: js-dialog-size1200x700

Step-3
=====

Go to Function and Global Variable Declaration:

// value set for PO Details

document.addEventListener("click", function(e) {

    if (e.target && e.target.classList.contains("set-po")) {

        var po_id = e.target.getAttribute("data-id");

        $s("P22001_PR_HEADER_ID", po_id);

    }

});

Select P22001_PR_HEADER_ID, then Create Dynamic Action.

Action Name: OPEN REGION

Event: Change

Selection Type: Item(s)

Item(s): P22001_PR_HEADER_ID

True Action: Open Region

Affected Elements:

Selection Type: Region

Region: PR Details

Again 
True Action: Refresh

Affected Elements:

Selection Type: Region

Region: PR Details

==============================================================

Select Report Region PK id Column (Ex: Department_Id)

HTML Expression :

<a href="javascript:$s('P9_DEPARTMENT_ID','#DEPARTMENT_ID#'),$s('P9_DEPARTMENT_NAME','#DEPARTMENT_NAME#')">#DEPARTMENT_ID#</a>