Answer Posted / dinesh a.

Create a report in drill down manner.

1) create a report only for deptno

then go onto report layout editor
create a push button

write code on push button to call another report base on
deptno. (please see srw.run_report )

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

1115

---

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1000

---

if u want to delete all these detail block etc what will happen in form

1969

---

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...

2156

---

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

2029

---

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

1016

---

difference between global n context sensitive segments?

2657

---

List out the oracle forms configuration files?

1060

---

what is tripstop report?

1813

---

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

2198

---

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

1663

---

did u received a single file or multiple files

2002

---

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

1067

---

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

2107

---

Name the different triggers supported by oracle reports and their firing order.

1064

---