Hire me on UpWork

Friday, April 5, 2013

How to Make Drill Down (Hyperlink) Report in Oracle Reports 10g/11g?


Greetings in Islamic way “As salamualikum”

Hyperlink reports in oracle means call another report from a report by clicking at a value.  For example, we have a report like bellow,
ID
Name
10001
Abdul Hamid
10002
Hamidur Rahman Siddique

And we want to call another report named DETAIL_INFO of a person by clicking on ID. How can we achieve this?

My example also helps to Hiding username/password when calling a report from another report

Follow the bellow steps and you are done.
1.       First stop the report server. (OC4J instance also for 10g)
2.       Search for CGICMD.DAT file in Developersuite home. (for 10g It’s located at <DevSuiteHome_1\reports\conf> folder. And for 11g D:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.1.2\configuration)
3.       Open the CGICMD.DAT file and go to bottom line and add the bellow lines and modify as your value.

 ; ** MY DEFINE ** BY ** HAMIDHELAL **
hrs: userid=test/password@orcl server=rep_server desformat=pdf destype=cache paramform=no %*
(Where first userid, report server name, report destination format, destination type and no parameter form.)
4.       Save and close the file.
5.       Now open the report which will have the link.
6.       Select the data field and press F11 to go code editor and add the bellow code before
return (true);
SRW.SET_HYPERLINK('http://SERVER_NAME:8889/reports/rwservlet?hrs+report='D:\ID_CARD_ALL.rep+EMPID='||:EMP_ID);
(Change the report server url as you have, report name and parameter if you have)

Compile and save the reports. If needs convert to any other extension.

Now Run the report server and run your report…

You are done :)
 
Hope this helps…

11 comments:

  1. Wonderful ... Thanks

    ReplyDelete
  2. Hi,

    I have RDF report(paper layout)i need to create hyperlink to the field(say CF column)..Please suggest step by step process how can i create hyperlink on that fields value, if possible please explain with screen shots.

    The hyperlink text should be differentiate from other text.Suppose that i want hyperlink on "Hello"(The hello should be in blue color and underlined, when i click on Hello it should navigate me to say google page.)

    Please Help me!
    Thanks in Advance!!

    ReplyDelete
  3. Wonderful ... Jazakallah Hamid.

    ReplyDelete
  4. How to open Drill down report in new window .

    ReplyDelete
  5. HI,
    NEED TO KNOW HOW TO PASS MORE THAN ONE PARAMETER
    THANKS

    ReplyDelete
  6. I want to call my html report from .rdf report can anyone help me??

    ReplyDelete
    Replies
    1. Do you not able to follow the above procedure ?

      Delete
  7. Assalam o Alikum,

    JazakAllah Hamid for this great information.
    Kindly explain one thing by changing .DAT file in devlopersuite home it only effects that particular machine is it ?

    And from where i get the report server name in Oracle EBS R12.1?

    JazakAllah once again

    ReplyDelete
    Replies
    1. As salamualikum Azeem Yahya,

      walikum as salam.

      at you know, application server change will effect all client those are using this application server.

      Normally if you run http://hostname.domain:port/reports/rwservlet/getserverinfo? then you will get report server name.

      JazakAllah

      Delete
    2. Wa Alaikum Salam,

      If em not getting wrong developer suit is install on developers end machine not on application server machine ?

      Delete