Answer / guest

By setting the action associated with button to Execute
pl/sql option and using the SRW.Run_report function.

Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;

2 Answers   TCS,

---

what u write in Ctl file

2 Answers  

---

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 Answers  

---

how do u call a report from form

3 Answers   Wipro,

---

What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?

1 Answers  

---

---

What are modal windows?

1 Answers  

---

What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

1 Answers  

---

State the order in which these triggers are executed ?

1 Answers  

---

What do you understand by lov and how can it be used?

0 Answers  

---

What is the use of Data Link in Reports?

3 Answers   BN, Convergys,

---

What is the usage of the confine mode in Layout Editor ?

2 Answers   Convergys,

---

explain about content canvas views?

1 Answers  

---