I HAVE A REPORT LAYOUT LIKE THIS
RUNDATE -FIELD DEPTNO-FIELD
------------------------------------------------------------
-------------------
EMPNO-----ENAME------SAL-----COMM----MGR-----
------------------------------------------------------------
------------------
------- ------------ -------- -------- --------
MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE
PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE.
I WANT LIKE THIS ....
Answer Posted / nabi
goto repeating frame property palletese
and set maximun number of records= 1
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we invoke one form from another in a multi-forms application?
Explain how can you use the same lov for 2 columns?
difference between global n context sensitive segments?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Explain master-detail relationship with some examples.
What is a matrix report and how many minimum groups are required to prepare the same?
i am writing a query select EmpNo from Emp how can i call in after parameter form
What do you understand by oracle forms?
how do u place it in required folder
where do u put the report file
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
what is oracle forms?
a text item is there what r the different types of triggers associated with it
How can we generate report output in excel format?