Home » Developer & Programmer » Reports & Discoverer » how to get Crosstab format report using Report dev 6i/10g  () 1 Vote
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

Previous Topic: how to create subreport in Report 6i?
Next Topic: passing parameters...
Goto Forum:
  


Current Time: Sat Dec 03 20:36:12 CST 2016

Total time taken to generate the page: 0.11171 seconds