New to Java

i have created a databse table in MSSQL 2000 like this

[empcode] [leave_date] [type] [reason]
--------------------------------------------------------------------------------------
100 2008-12-29 00:00:00.000 T Tour
100 2008-12-30 00:00:00.000 T Tour
101 2008-12-31 00:00:00.000 CL Casual Leave
102 2009-01-01 00:00:00.000 R Restricted holiday
100 2009-01-02 00:00:00.000 T Tour

This table contains only leave details....
but i need to create monthly attendance report such as below

empcode 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 .............
-----------------------------------------------------------------------------------------------------
100 P P P P S P T CL P P P S P P T ............
101 P T R R S R R T CL P P S P P P..............
102 P P P P S P P P P T T S CL P P P............


P-present
T-Tour
CL- causal leave
R- Restricted holiday
S-sunday

is there any way in Jasper Report to create report as above......
OR any SQL query to get the report like that.....

Thanks