| how to get Crosstab format report using Report dev 6i/10g [message #259515] |
Wed, 15 August 2007 15:34 |
ford_orafaq
Messages: 5
Registered: July 2007
|
Junior Member |
|
|
Hi,
Can anybody tell how to get the report in following format? That one is not exactly crosstab format.
---------------------------------------------------------------
<------------------------------> 01-jan-2007<----> 02-jan-2007...
---------------------------------------------------------------
Number of Employees Joined<----------> 2<------------>1 .......
Total Number of Employees<------------>2<------------->3......
---------------------------------------------------------------
** "<------------->" used to provide the information clearly only
Is it possible to get such report? Don't worry about the values. I have summary table to update over night in which i have exact columns as follows:
Table: EMP_SUMMARY_TABLE
Structure of the table:
----------------------------------------------------------
HIRE_DATE---->NUMBER_OF_EMP_JOINED---->TOTAL_NUMBER_OF_EMP
-----------------------------------------------------------
01-JAN-2007<------------>2<-------------------->2
02-JAN-2007<------------>1<-------------------->3...........
-----------------------------------------------------------
Anybody can help me out. The requirement is in high priority.
Thanks
[Updated on: Wed, 15 August 2007 15:52] Report message to a moderator |
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
