Expanding upon something someone already suggested, try something like this:

select  empId, ;
        year, ;
        month, ;
        DayNr, ;
        Leave, ;
        0 AS Total ;
   from MyTable ;
union all ;
select   emp_id, ;
         year, ;
         month, ;
         99 as DayNr, ;
         Leave, ;
         count(*) AS Total ;
    from MyTable ;
    GROUP BY 1, 2, 3, 5 ;
order by 1,2,3,4,5 ;
INTO CURSOR MyCursor

What you can do now is add the fields to the detail band. Create a Data Group with the expression of "DayNr = 99", without the quotes. This will give you an opportunity to use the Group Header band to create some white space and add some column titles that you want printed just before the totals for an employee.

You can use Print When logic in each field in the detail band to determine which ones you want printed when it's a true detail record (DayNr <> 99) or when it's a total record (DayNr = 99).

Play around with this concept and see if it helps you get what you want.