Answer / 147037

Click the LOV icon in the object navigator and choose ur
option of a manual or wizard .
A record group will be authomatically created depending on
the LOV.

Answer / pranita kochar

In the ‘Object Navigator’ window, select the LOVs object known as "List of values."
Then click on the green ‘+’ (Create) icon. In the ‘New List Of Value’ window, leave the default radio button which is: ‘Use the LOV Wizard’ and the click ‘OK.’
LOVs get their data from Record Groups, which may be populated using SQL queries, or by entering a static list of values. In the LOV Wizard window, use the default to base your LOV on a new Record Group; and then click ‘Next.’
In the ‘SQL Query Statement’ box, write a ‘SQL’ statement to query customers name and their ID. Then click ‘Next.’
(SQL Query Statement)

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

0 Answers  

---

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

0 Answers  

---

What is a physical page ? & What is a logical page ?

2 Answers   Techbooks,

---

Can you change the color of the push button in design time?

2 Answers  

---

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.

0 Answers  

---

---

How can you hide the report in Apps?

1 Answers  

---

What triggers are associated with the radio group?

1 Answers  

---

Is it possible to have multiple layouts in a report?

0 Answers  

---

how to create parameterised form in oracle 10g? and create another form from the value of the form? AND how to assign value to a parameter? sincerly your mamun

2 Answers  

---

What is the built-in used for showing lov at runtime?

1 Answers  

---

What is the content view and stacked view?

2 Answers  

---

Suppose I want to fire block level sequence before form level, then is it possible?

1 Answers  

---