Home/ Questions/Q 446
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-09-09T12:27:25+00:00

Interactive Report dynamic multiple page link in Oracle Apex

  • 1
  • 1

Hello Sir I want to add multiple page link in Interactive report only 1 column when I click then open page 4 page 5 etc.

dynamicirlink
Share
Leave an answer

Leave an answer

Browse

6 Answers

  1. My last answer was not correct for your requirement.

    To add multiple links in one column of the interactive report, use the HTML expression, and add the links as follows:

    <a href="f?p=&APP_ID.:1:&APP_SESSION.:::1">link 1 </a>
<a href="f?p=&APP_ID.:12:&APP_SESSION.:::12">link 2 </a>

    Below is the screenshot:

    HTML expression in IR report.

    Output:

    Multiple links in one column of IR report.

  2. This answer was edited.

    If your requirement is to open the different pages conditionally, then you have to create the link in your report query.

    A link could be changed to open different pages based on a particular column value. Below is an example of an IR report query with a dynamic link column:

    Select empno, ename, deptno, 
    case when deptno = 10 then
       'f?p=&APP_ID.:4:&APP_SESSION.:::4:P4_EMPNO:'||empno
    else
      'f?p=&APP_ID.:5:&APP_SESSION.:::5:P5_EMPNO:'||empno
    end case link_column
From EMP

    In the above SQL query if the deptno value is 10 then it will open page 4 by passing an empno as a parameter to the target page else it will open page 5 with the same parameter.

    Now suppose you want to make the empno column as a link then for the link target property define the #LINK_COLUMN# as shown in the below image: Link target property in Oracle Apex.