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?

What is an oracle report? List its various types.

630

---

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2538

---

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

1777

---

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

595

---

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1643

---

---

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

1937

---

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

1784

---

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

636

---

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1633

---

List out the oracle forms configuration files?

664

---

Explain how can you use the same lov for 2 columns?

726

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

1776

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

1694

---

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

913

---

What do we mean by record group in oracle forms?

692

---