Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Linking Pages in Interactive Report (Apex 4.0)
Linking Pages in Interactive Report [message #528981] Thu, 27 October 2011 17:39 Go to next message
Messages: 5
Registered: October 2011
Junior Member
Please Excuse the simple question, I'm Just beginning.

I have a master table and have created an interactive report for it. This is what I have so far:

Ive been trying to follow this: http://st-curriculum.oracle.com/obe/db/apex/r40/apexirr/apexirradv/apexirradv_ll.htm#t1

But I cant seem to link to an IR_ column.
I tried to link my id column was linked to
IR_Monthly Report Id

Do I need to use variables in my PL/SQL code?

I feel like I am missing something really basic. Ive tried using a row fetch process but to be honest I dont know enough about APEX yet, Ive tried following a few text books but mostly Ive found the APEX books Ive read hard to follow and theres really only so much i really learn from demo programs.

Also I apologise for the description - I cannot post links.

[EDITED by LF: applied "http://" to URLs]

[Updated on: Fri, 28 October 2011 01:10] by Moderator

Report message to a moderator

Re: Linking Pages in Interactive Report [message #528994 is a reply to message #528981] Fri, 28 October 2011 01:09 Go to previous messageGo to next message
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure I understood what you didn't understand. The instructions are quite strightforward. You should take target page's URL and copy it into column link's URL field. Here:


I don't know whether you read the "official" Apex documentation. It is quite well written. Doesn't cover certain (let's call them "advanced" features), but the documentation along with the OTN Apex forum (not to mention blogs) makes up a really good knowledge source.
Re: Linking Pages in Interactive Report [message #529285 is a reply to message #528994] Sun, 30 October 2011 15:00 Go to previous message
Messages: 5
Registered: October 2011
Junior Member
Hi, Thanks for the response It wasn't explained very well. I was trying to link a master table to the child table data(i.e. pass the parent table id to another page so the IR generated on that page was only getting the child data that was linked to the parent table from the parent table id).
I did look through the apex documentation when I started and I did a comprehensive search for the answer (posting wasn't my first thought) and what I've listed was all I could find (It was linked to the wrong section, sorry. It was meant to be linked to this section: "Creating a Declarative Filter".)

I read a few things that seem to tell me that using the URL to pass information through wasn't good practice, Is this wrong? (I was using a page as the target.)

I worked it out eventually by using a couple of different things. I needed a Hidden Item to pass the information too so that the IR was generated using the id (also a link) from the first page. And I used a Computation to create the hidden item in my 2nd page from my first page. In my 2nd page i did a fetch row process and then linked it to the column I was generating in my report.
Previous Topic: SYSDATE in success message
Next Topic: Pagination Error when filtering in an Interactive Report
Goto Forum:

Current Time: Sun May 26 18:27:59 CDT 2024