عندي فورم وفيه print button
انا عملت برسيدجر وكتبت فيها هالكود
PROCEDURE RUN_REPORT_OBJECT_PROC (vc_reportoj Varchar2, vc_reportserver varchar2, vc_runformat varchar2) IS


v_report_id Report_Object;

vc_ReportServerJob VARCHAR2(100); /* unique id for each Report request */

vc_rep_status VARCHAR2(100); /* status of the Report job */

vjob_id VARCHAR2(100); /* job_id as number only string*/


BEGIN


/* Get a handle to the Report Object itself. */
--:ADMEMPL_SVC_NO_PK

v_report_id := FIND_REPORT_OBJECT('Emp_SVC_Reoprt');

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);


/* Define the report output format and the name of the Reports Server as well as a user-defined parameter, passing the department number from Forms to the Report. There's no need for a parameter form to be displayed, so paramform is set to "no". */

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,vc_runformat);

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,vc_reportserver);

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'p_emp_svc='||:ADMEMPL010.ADMEMPL_SVC_NO_PK||'paramform=no');

vc_ReportServerJob := RUN_REPORT_OBJECT('Emp_SVC_Reoprt');

vjob_id := substr(vc_ReportServerJob,length('http://192.168.1.3:1521/')+2,length(vc_ReportServerJob));

/* If finished, check the report status . */

vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);

IF vc_rep_status='FINISHED' THEN

/* Call the Reports output to be displayed in a separate browser
window. The URL for relative addressing is valid only when the Reports
Server resides on the same host as the Forms Server. For accessing a
remote Reports, you must use the prefix http://hostname:port/ */


WEB.SHOW_DOCUMENT ('/reports/rwservlet/getjobid4'|| vjob_id||'?server=''http://192.168.1.3:1521/','_blank');
web.show_document('http://localhost:1521/reports/rwservlet?report=D:\PMS_PROJECT\Emp_SVC_Reoprt.jsp&destype=cache&desformat=HTMLCSS&userid=pms/pms1@pms&p_emp_svc='||:ADMEMPL010.ADMEMPL_SVC_NO_PK);

web.show_document('http://localhost:7777/reports/rwservlet?report=c:\ur_project\reports&destype=cache&desformat=HTMLCSS&userid=scott/tiger@ora&P_EMPNO='||:block_name.employee_id);

ELSE

message ('Report failed with error message '||vc_rep_status);

END IF;

END;

لاكن لما اشغل الفورم واحاول استدعي الريبورت تضهرلي هالمشكله
frm-41219 cannot find report:invalid ID
ساعدوني بليز ولاترى مديري بيعصب علي

يمكنك استخدام خاصية اظهار الكود .. من المفاتيح باعلى المشاركة
لكى يكون سهل المتابعه من الاعضاء
كالتالى

PROCEDURE RUN_REPORT_OBJECT_PROC (vc_reportoj Varchar2, vc_reportserver varchar2, vc_runformat varchar2) IS


v_report_id Report_Object;

vc_ReportServerJob VARCHAR2(100); /* unique id for each Report request */

vc_rep_status VARCHAR2(100); /* status of the Report job */

vjob_id VARCHAR2(100); /* job_id as number only string*/


BEGIN


/* Get a handle to the Report Object itself. */
--:ADMEMPL_SVC_NO_PK

v_report_id := FIND_REPORT_OBJECT('Emp_SVC_Reoprt');

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);


/* Define the report output format and the name of the Reports Server as well as a user-defined parameter, passing the department number from Forms to the Report. There's no need for a parameter form to be displayed, so paramform is set to "no". */

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,vc_runformat);

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,vc_reportserver);

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'p_emp_svc='||:ADMEMPL010.ADMEMPL_SVC_NO_PK||'paramform=no');

vc_ReportServerJob := RUN_REPORT_OBJECT('Emp_SVC_Reoprt');

vjob_id := substr(vc_ReportServerJob,length('http://192.168.1.3:1521/')+2,length(vc_ReportServerJob));

/* If finished, check the report status . */

vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);

IF vc_rep_status='FINISHED' THEN

/* Call the Reports output to be displayed in a separate browser
window. The URL for relative addressing is valid only when the Reports
Server resides on the same host as the Forms Server. For accessing a
remote Reports, you must use the prefix http://hostname:port/ */


WEB.SHOW_DOCUMENT ('/reports/rwservlet/getjobid4'|| vjob_id||'?server=''http://192.168.1.3:1521/','_blank');
web.show_document('http://localhost:1521/reports/rwservlet?report=D:\PMS_PROJECT\Emp_SVC_Reoprt.jsp&destype=cache&desformat=HTMLCSS&userid=pms/pms1@pms&p_emp_svc='||:ADMEMPL010.ADMEMPL_SVC_NO_PK);

web.show_document('http://localhost:7777/reports/rwservlet?report=c:\ur_project\reports&destype=cache&desformat=HTMLCSS&userid=scott/tiger@ora&P_EMPNO='||:block_name.employee_id);

ELSE

message ('Report failed with error message '||vc_rep_status);

END IF;

END;

ايضا : توجد مشاركات عديده لنفس الموضوع .. يمكن استخدام خاصية البحث بالمنتدى .. اذا اردت ذلك