Home » Developer & Programmer » Forms » How to run report in oracle form 12c (Window server 2008 , oracle 12c , oracle forms12c )
How to run report in oracle form 12c [message #662580] Sat, 06 May 2017 04:01 Go to next message
NIJ1611
Messages: 17
Registered: February 2017
Junior Member
Dear sir ,

Please give me any suggestion to how to run oracle 12c report .





Thanks & Regards
Re: How to run report in oracle form 12c [message #662586 is a reply to message #662580] Sat, 06 May 2017 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

With care and efficiency.

Re: How to run report in oracle form 12c [message #662644 is a reply to message #662580] Mon, 08 May 2017 13:02 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Same as in 11g.
Re: How to run report in oracle form 12c [message #663218 is a reply to message #662580] Fri, 26 May 2017 01:26 Go to previous messageGo to next message
Tanishq
Messages: 1
Registered: May 2017
Junior Member
hello ,

I have code for calling report on 12c

firstly create a button
on when-button-pressed trigger

copy below code:

DECLARE
pl_id Paramlist;
pl_name varchar2(20):= 'tempdata';
v_report_id report_object;
vc_rep_status varchar2(200);
vc_ReportServerJob varchar2(100);
vjob_id varchar2(200);
begin

pl_id := get_parameter_list(pl_name);

if not id_null (pl_id)
then
destroy_parameter_list(pl_id);
end if;

pl_id := create_parameter_list(pl_name);


v_report_id :=find_report_object('report_name');


SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,pdf);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE, cache);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,'report_server_name');
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'PARAMFORM=NO');

vc_ReportServerJob := run_report_object('report_name');

vjob_id := substr(vc_ReportServerJob,instr(vc_ReportServerJob,'_',-1)+1); --
vc_rep_status := report_object_status(vc_ReportServerJob);
if vc_rep_status = 'FINISHED'
then
web.show_document('http://192.168.100.222:9002/reports/rwservlet/getjobid'||vjob_id||'?server=my_server1');
else
message('Report failed with error message '|| vc_rep_status);
end if;
end;

Note:
-you should know report server port no. and url and report server name
-you need to attach created report on form and that report name you have call in RUN_REPORT_OBJECT


I HAVE ATTACHED FORM BY USING IT YOU LL DEFINATELY UNDERSTAND THE CALLING PROCESS
  • Attachment: MODULE1.fmb
    (Size: 48.00KB, Downloaded 3332 times)
Re: How to run report in oracle form 12c [message #663220 is a reply to message #663218] Fri, 26 May 2017 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

Re: How to run report in oracle form 12c [message #678512 is a reply to message #663218] Mon, 09 December 2019 23:59 Go to previous messageGo to next message
irfan9224
Messages: 1
Registered: December 2019
Junior Member
Do we need rp2rro.dll for report calling in oracle 12c?. Actually i migrated forms from 10g to 12c . Forms are running. but i am unable to call report on 12 c
Re: How to run report in oracle form 12c [message #688113 is a reply to message #663218] Fri, 25 August 2023 00:39 Go to previous message
Umar Afzal
Messages: 1
Registered: August 2023
Junior Member
how to create this job id procedure in Database
Previous Topic: Debug Assertion Failed / assertion failed ifdbg60.exe error
Next Topic: how to disable menu item
Goto Forum:
  


Current Time: Thu Mar 28 18:24:23 CDT 2024