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
No Answer is Posted For this Question
Be the First to Post Answer
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.
Where we can use the placeholder columns?
Is it possible to disable the parameter from while running the report?
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
How many Flexfields are there in AR and what are they ?
What is the Maximum allowed length of Record group Column?
What are the different Parameter types?
How many windows in a form can have console?
What is an User Exits ?
What are the built-ins used for finding Object ID function?
How can you hide the report in Apps?
what are the new features introduced in oracle form services in 11g release 2?