Answer Posted / sudipta santra

The function will be like that:-

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 or aiv.INVOICE_DATE between
:from_invoice_date and :to_invoice_date then
aiv.PERIOD_NMAE:=<insert value>
end if;

return (TRUE);
end;

Like that way it will be solved. In else part the assigned
value should be fixed how it would between two range of date?

did u p prepared complex report

1949

---

What is a matrix report and how many minimum groups are required to prepare the same?

1059

---

where do u put the report file

2043

---

List out the oracle forms configuration files?

1004

---

List the different types of columns in oracle reports.

936

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2047

---

What is an oracle report? List its various types.

917

---

What do you understand by lov?

982

---

What are the various configuration files that are used by oracle forms?

982

---

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

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2135

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1088

---

What do you understand by oracle forms and why are they required?

947

---

What do we mean by record group in oracle forms?

1025

---

how do u place it in required folder

1867

---