| Open Report From Form [message #164385] |
Thu, 23 March 2006 04:22  |
pam_W_85@yahoo.co.uk
Messages: 4
Registered: March 2006
Location: Manchester
|
Junior Member |
|
|
Hi I am trying to open a report using a button on a form in oracle form builder 10g. I am using the following code:
DECLARE
Report_Id REPORT_OBJECT;
Report_Job_Id VARCHAR2(20);
BEGIN
Report_Id := FIND_REPORT_OBJECT('Account_Balance9');
SET_REPORT_OBJECT_PROPERTY(Report_Id,REPORT_EXECUTION_MODE, RUNTIME);
SET_REPORT_OBJECT_PROPERTY(Report_Id,REPORT_FILENAME, 'Account_Balance.jsp');
SET_REPORT_OBJECT_PROPERTY(Report_Id,REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(Report_Id,REPORT_DESTYPE, SCREEN);
SET_REPORT_OBJECT_PROPERTY(Report_Id,REPORT_OTHER, 'PARAFORM=YES');
Report_Job_Id := RUN_REPORT_OBJECT(Report_Id);
END;
but I get the error:
cannot find report: invalid id
Any help would be great
Pam
|
|
|
|
| Re: Open Report From Form [message #164538 is a reply to message #164385] |
Thu, 23 March 2006 22:28  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Are you running 10gDS or 10gAS? Please consider using web.show_document. Search this forum for 'show_document' and 'run_report_object'. This question has been answered many times.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
