| Calling Report from Menu (Oracle Forms 11g) [message #468358] |
Thu, 29 July 2010 19:47 |
 |
jaramill
Messages: 10
Registered: January 2000
Location: Glendale, AZ
|
Junior Member |
|
|
I'm trying to call a report from a menu item in a menu (that is attached to a form) in Oracle Forms 11g directly and I'm having some difficulty. I know how to call a report from a form and everything works perfectly.
But since in a menu there is no item called "Report" to attach like there is in Forms, I followed on route which is to attach the "rp2rro" PL/SQL library on the menu file (mmb) and I also even did it on the form itself. Then when you convert a menu using the Forms Migration Assistant, it will comment out statements like "ADD_PARAMETER" and replace with calls to packaged procedures/functions from the package "rp2rro". I set all the parameters
RP2RRO.SETOTHERS('PARAMFORM=YES');
RP2RRO.SETDESTYPE('CACHE');
RP2RRO.SETDESFORMAT('PDF');
RP2RRO.SETCOMMUNICATIONMODE(SYNCHRONOUS);
then made the call to the report:
RP2RRO.RUN_PRODUCT(REPORTS, 'MYREPORT', SYNCHRONOUS, RUNTIME, FILESYSTEM, param_list_id, NULL);
but all i get is the error "FRM-41219: Cannot find report: invalid ID."
The Oracle documentation for integration reports in forms is for when you execute the report within a form not a menu item (that is attached to a form). Any clues?
My environment is:
Oracle (Database, Fusion Middleware) 11g - Red Hat Enterprise Linux 5
Web Browser - Internet Explorer 7 on Windows XP Professional
Thanks,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
