Home » Developer & Programmer » Reports & Discoverer » Hyperlink report to report (Windows 10 , Oracle Developer suite 10g , Xpress edition 10g)
Hyperlink report to report [message #687880] Mon, 10 July 2023 02:46 Go to next message
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=

Re: Hyperlink report to report [message #687882 is a reply to message #687880] Mon, 10 July 2023 03:39 Go to previous message
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

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


Current Time: Mon Jun 24 06:16:07 CDT 2024