Home » Developer & Programmer » Reports & Discoverer » Problem with running report from form (Developer 9i, XP)
Problem with running report from form [message #283621] Tue, 27 November 2007 13:41 Go to next message
janaq
Messages: 22
Registered: August 2007
Junior Member
Hello,

I am running my report from Form Button with When Button Press Trigger, but the report does not displays. When I click the button another browser windows open but it does not display the report. Please help me why is this happening.

DECLARE
	repid REPORT_OBJECT;
	v_rep VARCHAR2(100);
	rep_status VARCHAR2(20);

BEGIN
	repid := FIND_REPORT_OBJECT('REPORT6');
	v_rep := RUN_REPORT_OBJECT(repid);
	WEB.SHOW_DOCUMENT('http://202.143.122.33:8888/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=repserver90','_blank'); 
	message('running report'); 
END;
Re: Problem with running report from form [message #283908 is a reply to message #283621] Wed, 28 November 2007 07:00 Go to previous messageGo to next message
janaq
Messages: 22
Registered: August 2007
Junior Member
Please can any one help me.
Re: Problem with running report from form [message #288237 is a reply to message #283621] Sun, 16 December 2007 03:35 Go to previous messageGo to next message
janaq
Messages: 22
Registered: August 2007
Junior Member
Hello,

Is there any one who can help me with running the report in the developer 9i. I am still not able to see my report. Urgent help required.
Re: Problem with running report from form [message #288239 is a reply to message #288237] Sun, 16 December 2007 04:17 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is the pop-up blocker turned on?
Re: Problem with running report from form [message #288253 is a reply to message #288239] Sun, 16 December 2007 10:19 Go to previous messageGo to next message
janaq
Messages: 22
Registered: August 2007
Junior Member
Thanks alot for answering. The pop up block is off.


Re: Problem with running report from form [message #288256 is a reply to message #288253] Sun, 16 December 2007 12:03 Go to previous message
janaq
Messages: 22
Registered: August 2007
Junior Member
hi littlefoot,

i have tried this code also but the problem is same. the report is not displaying in the browser that opens on the button press.


DECLARE
	v_report_id Report_Object;
	vc_report_job_id VARCHAR2(100); /* unique id for each Report request */
	vc_rep_status VARCHAR2(100); /* status of the Report job */

BEGIN
	/* Get a handle to the Report Object itself. */
	v_report_id:= FIND_REPORT_OBJECT('REPORT7');
	message ('report found');

	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE, SYNCHRONOUS);

	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);

	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,'HTML');

	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER, 'repserver90');

	vc_report_job_id:=RUN_REPORT_OBJECT(v_report_id);
	message (vc_report_job_id);

	vc_rep_status := REPORT_OBJECT_STATUS(vc_report_job_id);
	message (vc_rep_status);

	IF vc_rep_status='FINISHED' 
		THEN
		web.show_document ('http://localhost:8888/reports/rwservlet/getjobid='
||vc_report_job_id ||'?server='|| 'repserver90','_blank');
	ELSE
		message ('Report failed with error message '||vc_rep_status);
	END IF;
END;


Please tell me where is the problem

Thanks & Regards.
Previous Topic: Problem during Character Mode Report Generation
Next Topic: Format Mask
Goto Forum:
  


Current Time: Tue Dec 06 04:29:54 CST 2016

Total time taken to generate the page: 0.20101 seconds