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.
āļø OrclQA.Com is a question and answer forum for programmers.
āļø Here anyone can ask questions and anyone can answer to help others.
āļø It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
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:
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:
Vinish Kapoor
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:
Below is the screenshot:
Output:
Zulqarnain Haider
Great Sir thankx alot.
Zulqarnain Haider
Vinish Kapoor
Use the following URL for it:
Zulqarnain Haider
Thankx alot sir.
Mani
Hi Vinish,
I want to do the same thing(call dialog page) but before saving the data on an interactive grid.
how can I do that plz guide me?
Mani
hi gurus,
i want to do the same thing but on interactive grid before saving the data .. how can we do that. plz guide.
Vinish Kapoor
Follow the same steps but instead of #LINK_COLUMN# use &LINK_COLUMN. .
ABDULLAH
hello Vlnlsh I have three cases A and L and C every case has an id I want to go to pageĀ one of three pages with the id to show the data referencing three cases (A,b,c) to go to page
ABDULLAH
I did
decode(REFERENCE_OBJECT_CODE,'A','f?p=&APP_ID.:10:&APP_SESSION.:::10:P10_ACCOUNT_ID:'||REFERENCE_OBJECT_ID,
'L','f?p=&APP_ID.:19:&APP_SESSION.:::19:P19_LEADS:' ||REFERENCE_OBJECT_ID,
'C','f?p=&APP_ID.:51:&APP_SESSION.:::51:P51_CONTACT_ID:'||REFERENCE_OBJECT_ID ,0 )LINK_COLOUMN,