OraFAQ Forum: Reports & Discoverer » SET

Home » Developer & Programmer » Reports & Discoverer » SET_HYPERLINK (Oracle Application Server version 10.1.2.0.2, Window Server 2003 R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SET_HYPERLINK [message #486785]

Mon, 20 December 2010 04:14

itroome
Messages: 34
Registered: June 2005
Location: DUBAI, UAE

Member

Dear Guru

I migrated the report from Developer 2000. This report has the drill down report with the following command.

procedure U_1ButtonAction is
begin
srw.run_report('rep022.rep paramform=no
p11="'||:cr_call_ref_no||'"');
end;

After Migration into Oracle Application Server 10g release 2 , I changed the code as following:

function U_1FormatTrigger return boolean is
begin

SRW.SET_HYPERLINK(' http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?report=E:\CallSystem\rep022.rdf&USERID=dss/dss@dsdb&destype=cache& ;desformat=pdf&p11="'||:cr_call_ref_no||'"');
return (TRUE);
end;

/forum/fa/8543/0/

-----------
Problem

When I run the report, it shows the toolbar on the link [with the user id & password] of the drilldown report.

I wish to hide the username & password or
I wish to enter my message "Click the link to open the Report".

Muhammad Aurangzaib
[mailto:itroome@yahoo.com|itroome@yahoo.com]

Attachment: set_hyperlink.GIF
(Size: 91.07KB, Downloaded 4813 times)

Report message to a moderator

Re: SET_HYPERLINK [message #486867 is a reply to message #486785]

Tue, 21 December 2010 00:16

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Quote:

I wish to hide the username & password

Please read this post.
http://www.orafaq.com/forum/m/463776/81953/#msg_463776

Regards,
Irfan

Report message to a moderator

Re: SET_HYPERLINK [message #486913 is a reply to message #486867]

Tue, 21 December 2010 04:08

itroome
Messages: 34
Registered: June 2005
Location: DUBAI, UAE

Member

Dear ranamirfan

I tryed to enter the key into the file cgicmd.dat as follow:

Cgicmd.dat
dssuser: userid=dss/dss@dsdb %*

and the try to run the report from the internet explorer as

http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?dssuser&report=E:\CallSystem\rep022.rdf&destype=cache&desformat=p df

Error:
REP-52005: The specified key dssuser does not exist in key map file.

Image Referance of cgicmd.dat and error REP-52005:
/forum/fa/8547/0/

In the Report I changed the Code as:
-----------------------------
function U_1FormatTrigger return boolean is
begin
SRW.SET_HYPERLINK(' http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?dssuser&report=E:\CallSystem\rep022.rdf&destype=cache&desformat=p df&p11="'||:cr_call_ref_no||'"');
return (TRUE);
end;
-----------------------------

Error:

REP-52005: The specified key dssuser does not exist in key map file.

Please correct me, if I am do wrong.

Muhammad Aurangzaib
itroome@yahoo.com

Attachment: cgicmd_error.GIF
(Size: 13.00KB, Downloaded 4755 times)

[Updated on: Tue, 21 December 2010 04:10]

Report message to a moderator

Re: SET_HYPERLINK [message #486914 is a reply to message #486913]

Tue, 21 December 2010 04:20

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,
Quote:

REP-52005:The specified key dssuser does not exist in key map file.

I m using Forms / Reports 11g.
After enter the key into the file cgicmd.dat we must restart our report server.For Restart Report Server we mostly used Weblogic Server.

Regards,
Irfan

Report message to a moderator