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

Post New Answer

More Oracle Forms Reports Interview Questions

in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........

1 Answers  


What is a Non Query Record Group?

1 Answers  


What are the three types of user exits available ?

1 Answers  


What does an on-clear-block Trigger fire?

1 Answers  


What are Most Common types of Complex master-detail relationships?

1 Answers  






what exactly u write in when_new_form_instance

0 Answers   TCS,


i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI smalipaki@yahoo.com

5 Answers  


What is the sequence the Report triggers will fires while running a report ?

1 Answers   FCS, GE,


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

0 Answers  


where do u put the report file

0 Answers  


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

0 Answers  


what is place holder column

3 Answers   Oracle, PCS,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)