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…
