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 )

Is it possible to have multiple layouts in a report?

1086

---

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

3044

---

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

1944

---

what is the difference between call_form, new_form and open_form?

1377

---

if some data is not transfered where it will get stored

1990

---

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

3042

---

Explain master-detail relationship with some examples.

1050

---

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1249

---

List out the oracle forms configuration files?

1124

---

what is tripstop report?

1900

---

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

2050

---

what is difference between group above and group left report

3869

---

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

1746

---

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

2096

---

What is an oracle report?

1118

---