Answer Posted / gaurav singh

PROCEDURE call_rep IS
BEGIN
declare
pi_id paramlist;
oth varchar2(30);
N_COPIES varchar2(5);
F_N VARCHAR2(30);
COD varchar(30);
typ VARCHAR2(1);
comp_code varchar2(2);
supplier_code number(6);
STORE_VAR VARCHAR2(50);
alrt_var number;

vc_reportserverjob varchar2(100);
report_job_id varchar2(100);
repid report_object;
v_rep_status varchar2(100);
begin
--------------------------------------
repid:=find_report_object('RP2RRO');


proc_path('path of ur rdf',store_var);
store_var:=store_var||rdf name';
set_report_object_property
(repid,report_filename,store_var);
set_report_object_property
(repid,report_server,:global.r_server);
set_report_object_property
(repid,report_execution_mode,runtime);
set_report_object_property
(repid,report_comm_mode,synchronous);
set_report_object_property
(repid,report_destype,cache);
set_report_object_property
(repid,report_desformat,:GLOBAL.dsfmt);
----------------------------------------------------
------


pi_id := get_parameter_list('it_param');
if not Id_null(pi_id) then
destroy_parameter_list(pi_id);
end if;

pi_id := create_parameter_list('it_param');

add_parameter(pi_id,'order_no',TEXT_PARAMETER,COD);
add_parameter
(pi_id,'order_date',TEXT_PARAMETER,to_char
add_parameter(pi_id,'comp_code',TEXT_PARAMETER,comp_code);
add_parameter
(pi_id,'supplier_code',TEXT_PARAMETER,supplier_code);
add_parameter
(pi_id,'PARAMFORM',TEXT_PARAMETER,'NO');




vc_reportserverjob := RUN_REPORT_OBJECT
(repid,pi_id);
report_job_id:=substr
(vc_reportserverjob,length(:global.r_server)+2,length
(vc_reportserverjob));
v_rep_status:=report_object_status
(vc_reportserverjob);

if v_rep_status='FINISHED' then
web.show_document
('http://'||:global.host||':'||:global.port||'/reports/rwser
vlet/getjobid'|| report_job_id||'?
server='||:global.r_server,'_blank');
else
message ('error when running report'||v_rep_status);
end if;


go_item('dt_pur_order.nu_price');
show_view('cg$page_1');
end;
END;

why the Ctl file u put only in bin folder why not in other folder

1993

---

what is the difference between call_form, new_form and open_form?

1213

---

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4549

---

Name the different triggers associated with oracle forms having a master-detail relationship.

919

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1232

---

How to create Drill down report?

2072

---

what is difference between group above and group left report

3759

---

how do u place it in required folder

1867

---

did u p prepared complex report

1949

---

how to send file attachment from oracle forms

2488

---

what exactly u write in when_new_form_instance

3376

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1623

---

List the different types of columns in oracle reports.

936

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

1983

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2240

---