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
What is an oracle report? List its various types.
How to solve the error ?Frequency below its group? while running the report. Why it is happened and How to solve that?
What are the different window events activated at runtimes?
How can I message to passed to the user from reports?
how do u place it in required folder
What is the difference between OLE Server & Ole Container?
How the Action Trigger works? and what is full syntex of srw.run_report?
1 Answers CMC, Yantro Software,
What are the important difference between property clause and visual attributes?
What are three panes that appear in the run time pl/sql interpreter?
If two groups are not linked in the data model editor, What is the hierarchy between them?
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
Where do u define the select statement of the parameter? is it followed by the & variable ?