OraFAQ Forum: Reports & Discoverer » Hyperlink report to report

Home » Developer & Programmer » Reports & Discoverer » Hyperlink report to report (Windows 10 , Oracle Developer suite 10g , Xpress edition 10g)

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

Hyperlink report to report [message #687880]

Mon, 10 July 2023 02:46

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Dear All,

Good Day!

when i run my report with software with its working fine the query is

http://192.168.0.113:8889/reports/rwservlet?userid=faizan/a@xe&server=rep60server&report=c:\farazoracle\10gReports\Ledger.rep &destype=CACHE&desformat=PDF&paramform=no&date_from=10-JUL-23&date_to=10-JUL-23&acc_id_from=1002&acc_id_t o=1002&Catagory_from=1002&Catagory_to=1002&Bl_noo=&bl_lot_noo=&Lot_no_sm=&SUPPLIERR=&cleared_byy=&cha ssis_noo=&codee=&modell=&yardd=&colorr=&Companyy=DAA&Remarks=

but when i make hyperlink to call this report its automatically shift Destype to file and Desformat disappare

http://192.168.0.113:8889/reports/rwservlet?userid=faizan/a@xe&server=rep60server&report=c:\farazoracle\10gReports\Ledger.rep File=CACHE%20pdf=PDF%20&paramform=no01-JAN-23=:Date_from08-JUL-23=:Date_to====&Bl_noo=&bl_lot_noo=&Lot_no_sm=&SUP PLIERR=&cleared_byy=&chassis_noo=&codee=&modell=&yardd=&colorr=&Companyy=DAA&Remarks=

Report message to a moderator

Re: Hyperlink report to report [message #687882 is a reply to message #687880]

Mon, 10 July 2023 03:39

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Its worked for me when i try

Quote:

function F_TO_CHAR_ACC_ID1FormatTrigger return boolean is
begin

SRW.SET_HYPERLINK(' http://192.168.0.113:8889/reports/rwservlet?userid=faizan/a@xe&server=rep60server&report=c:\farazoracle\10gReports\Ledger.rep &destype=CACHE&desformat=PDF&paramform=no
&date_from="'||:date_from||'"
&date_to="'||:date_to||'"
&acc_id_from=acc_id1');

-- Automatically Generated from Report Builder.
if (:CONTROL_DETAIL = '1')
then
   srw.set_foreground_border_color('darkblue');
   srw.set_border_pattern('solid');
   srw.set_foreground_fill_color('white');
   srw.set_fill_pattern('solid');
   srw.set_text_color('darkblue');
   srw.set_font_face('Arial');
   srw.set_font_size(16);
   srw.set_font_weight(srw.bold_weight);
   srw.set_font_style(srw.plain_style);
end if;

return (TRUE);
end;

Previously i am trying to do hyperlink with the properties but now i try with plsql

Report message to a moderator

Previous Topic:	RPT2XLS issues
Next Topic:	subject total in matrix with group report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 05:41:51 CDT 2024