Home » Developer & Programmer » Forms » Report does not open automatically
Report does not open automatically [message #294250] Wed, 16 January 2008 23:47 Go to next message
ShaShalini
Messages: 59
Registered: January 2007
Member
Hi

I am calling a report from a forms. I open the form in pdf. Everytime a pop up comes and ask to opne or save the file. If saved and then opened in Acrobat reader , its ok , the report has run successfully and saved. But I want the report to open automatically withoout being prompted to open/save.

Here is the code used to open a report. Is it something related to browser . Because while developing the forms , th developers are able to open report directly, but at client place we are getting the problem. Both Development Team and client place has the same version of Application Server 10g .

The code is --


BEGIN
v_report_server := cmsGetCounter.db_get_repserver;
v_report_id := FIND_REPORT_OBJECT(p_rep_name);
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,'PDF');
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,v_report_server);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'p_start_date='||:param.date_from||' p_end_date='||:param.date_to);
vc_ReportServerJob := RUN_REPORT_OBJECT(v_report_id);
vjob_id := substr(vc_ReportServerJob,length(v_report_server)+2,length(vc_ReportServerJob));
vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);
IF vc_rep_status = 'FINISHED' THEN
WEB.SHOW_DOCUMENT ('/reports/rwservlet/getjobid'|| vjob_id||'?server='||v_report_server,'_blank');
ELSE
Alerts.stop_alert ('Report failed with error message '||vc_rep_status,choice);
END IF;
return (vc_rep_status);
END;
Re: Report does not open automatically [message #296142 is a reply to message #294250] Thu, 24 January 2008 17:23 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Skip the 'RUN_REPORT_OBJECT' call and just do the 'WEB.SHOW_DOCUMENT' call. See what happens.

David
Previous Topic: Need to ask password if the menu module is ideal for certain time
Next Topic: Telephone directory form
Goto Forum:
  


Current Time: Thu Feb 13 12:18:42 CST 2025