I have the following query which generates a report as follows...
Code:
   select b.employee_name, a.activity_occured_date, sum(a.timespent)
   from d_ts_entries a, u_hris.d_hris_personal b
   where a.fk_employee_id = b.employee_id and to_char(a.activity_occured_date, 'MM') = '04' AND
   TO_CHAR(a.activity_occured_date, 'YYYY') = '2003'
   group by b.employee_name, a.activity_occured_date;
PROJECT_NAME ON_DATE TOTAL_TIME_SPENT
------------------------- --------- ----------------
CTG 01-APR-03 534.55
02-APR-03 524.8
03-APR-03 528.3
04-APR-03 525.7
However, the requirement is to display the report as follows...

PROJECT_NAME 01-APR-03 02-APR-03 03-APR-04
CTG 534.55 524.8 528.3

How can this be achieved?

Thanks.