Apps2Fusion.com

Forum for Oracle eBusiness Suite Topics

Skip to content


Advanced search
  • Board index ‹ Development & Customization in Oracle Apps ‹ Customization of Forms, Reports, Workflows, AME & Discoverer in Apps ‹ Oracle Report customizations
  • Change font size
  • Print view
  • FAQ
  • Register
  • Login

calling custom reports from forms menu

Report Customizations
``````````````````````

Moderators: kishore.ryali, anilpassi

  • • View active topics
Post a reply
1 post • Page 1 of 1

calling custom reports from forms menu

Postby ddoracle on Tue Oct 14, 2008 8:01 am

hi,
Im working on custom forms and reports upgrade from 11i to r12.
My forms are working fine. I m trying to call a report from forms menu.
I have button named reports in forms, when i click my report has to be called. I heard in r12 , there is no report server. I found in config files, its an IN PROCESS SERVER.
when i run in forms builder local machine, giving my machine name say -http://sys111:8889/reports/rwservlet/?with my report name-i get output and report status.
But when i try to run from r12 server, giving my hostname,its shows page not found.
In forms plsql editor, i used run_report_object procedure
and use web.show_document ('/reports/rwservlet/getjobid='||vc_report_job_id||'?_blank');
is rwservlet applicable in r12? i have both forms and reports server together as application server. wat is been wrong? somthing els has to configured in server end.Please advice.

here is my code
[PROCEDURE RUN_REPORT_OBJECT_PROC
(vc_reportname Varchar2,
vc_reportserver varchar2,
vc_runformat varchar2) IS
v_report_id Report_Object;
vc_report_job_id VARCHAR2(100); /* unique id for each Report request */
vc_rep_status VARCHAR2(20); /* status of the Report job */

BEGIN

v_report_id:= FIND_REPORT_OBJECT(vc_reportname);
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,vc_runformat);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,vc_reportserver);
vc_report_job_id:=RUN_REPORT_OBJECT(v_report_id);
vc_rep_status := REPORT_OBJECT_STATUS(vc_report_job_id);
IF vc_rep_status='FINISHED' THEN
web.show_document ('/devcgi/rwcgi.exe/getjobid='||vc_report_job_id||'?server='||vc_reportserver,'_blank');
--i changed the command to reports/rwservlet/---
ELSE
message ('Report failed with error message '||vc_rep_status);
END IF;
END;
]

can you pls advice..how to run the report from forms?
Thanks in advance.
ddoracle
 
Posts: 1
Joined: Tue Oct 14, 2008 7:53 am
Top

Post a reply
1 post • Page 1 of 1

Return to Oracle Report customizations

Who is online

Users browsing this forum: No registered users and 1 guest

  • Board index
  • The team • Delete all board cookies • All times are UTC [ DST ]
Powered by Focus Thread Limited © 2000, 2002, 2005, 2007