| Calling Reports9i from Forms 9i [message #85038] |
Mon, 24 May 2004 21:58  |
Abhik
Messages: 2
Registered: May 2004
|
Junior Member |
|
|
I have a package having forms in Forms6i. I have migrated the forms6i forms into Forms9i. However, I couldn't run the reports from Forms inspite of using RUN_REPORT_OBJECT(Reportname/ReportID). I have even updated the registry REPORTS_PATH. Still it is giving an error saying "Invalid Formspecification" subsequently it is giving an error "Run report object argument(1) cannot be null" .
could anyone help me in this reg.
Thanks in advance
|
|
|
|
| Re: Calling Reports9i from Forms 9i [message #85042 is a reply to message #85038] |
Tue, 25 May 2004 00:37  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Are you running the Report in Client Server or on the WEB?
In order to use RUN_REPORT_OBJECT make use of following Code:
Declare
report_id Report_Object;
report_message VARCHAR2(100);
Begin
report_id:= find_report_object('REPORT5');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,RUNTIME);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE); -- If on the WEB
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,'orepsn002'); --- If on the WEb elase set this to null.
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'paramform=NO');
message('report_id');pause;
report_message:=run_report_object(report_id);
message(report_message);pause;
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
