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;

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1490

---

what is difference between group above and group left report

3214

---

a text item is there what r the different types of triggers associated with it

1517

---

What is the difference between flex mode and confined mode?

534

---

What is a user exit program in oracle reports?

581

---

---

from where do u receive the information to develop report

1537

---

how do u place it in required folder

1480

---

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1101

---

What is the difference between bind and lexical parameter?

549

---

In what situation u create the BPA.

1779

---

what are bind variables?

600

---

Explain the various types of oracle report?

553

---

Is it possible to have multiple layouts in a report?

582

---

if some data is not transfered where it will get stored

1468

---

all steps of bitmap report?

1912

---