Hello,
Please find my code below where I have a parameter also . My question : is this the correct way to pass a parameter from a form to a report ?
Declare
Rep_server varchar2(1000);
Format varchar2(500);
Login_user varchar2(500);
Report_path varchar2(1000);
begin
Rep_server = 'http://xpmachine:8889/reports/rwservlet?;
Format := 'deformat=pdf&destype=cache';
Login_user = '&userid=username/password@db';
Report_path := ' &report=c:\payr004.rdf';
Web.showdocument(rep_server||format||login_user||report_path||'&p_deptno='||:control.deptno,'_blank');
end;