Matrix Report Problem

 Hi everyone, 

I have created a matrix attendance report by using following query: 

select EMPLOYEE_ID, ATTENDANCE_DATE, sum(td) td ,

from 

(

select EMPLOYEE_ID, ATTENDANCE_DATE, round((time_diff(time_in,time_out)/60/60),2) td

from HR_ATTENDANCE_DETAIL

where to_char(attendance_date,'mon-rrrr') =  to_char(:as_on_dt,'mon-rrrr')

--and employee_id = 1 

union all 

SELECT  1, (:as_on_dt+ LEVEL - 1)  , 0  

                     FROM DUAL

               CONNECT BY LEVEL <= to_number(to_char(last_day(:as_on_dt),'dd'))

) x

group by EMPLOYEE_ID, ATTENDANCE_DATE

order by 2

I dont see any problem with this query but when i try to insert leave_status column in matrix which is varchar2 it dont show me proper data, or show me data related to employee 1.