Report does not open automatically [message #294250] |
Wed, 16 January 2008 23:47  |
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;
|
|
|
|