OraFAQ Forum: Forms » Calling Web Report from Form

Home » Developer & Programmer » Forms » Calling Web Report from Form

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

Calling Web Report from Form [message #82377]

Thu, 22 May 2003 15:33

Raj
Messages: 411
Registered: November 1998

Senior Member

Can anyone tell me how to add the feature to invoke an existing web report from the form?

Thanks
Raj

Report message to a moderator

Re: Calling Web Report from Form [message #83455 is a reply to message #82377]

Fri, 10 October 2003 05:35

AbdulKhaliq
Messages: 11
Registered: August 2003

Junior Member

try it and enjoy:
DECLARE
rep_id REPORT_OBJECT;--report object type
v_rep VARCHAR2(1000);
V_NAME VARCHAR2(255);--object return name
V_RPT VARCHAR2(100);
V_JOBID VARCHAR2(100);--numeric part of job(rep_id);
BEGIN
rep_id := FIND_REPORT_OBJECT('YARN');
set_report_object_property(rep_id,report_other,'p_documentno='||:documentno);
v_rep := RUN_REPORT_OBJECT(rep_id);
V_NAME := v_rep;
V_JOBID := SUBSTR(v_name,instr(v_name,'_')+1);--rptsrv_=7+(1)
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||V_JOBID||'?server=rptsrv');
END;

Report message to a moderator

Previous Topic:	when-validate-item
Next Topic:	Calling Crystal reports from forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 02:11:53 CDT 2024