sql statement and crystal report

[louis]

I have a table which store data in the following format:
id number date
---------------------------
01 5 01-Aug-2003
01 2 01-Aug-2003
01 6 03-Aug-2003
..
..
01 8 31-Aug-2003
02 2 01-Aug-2003
02 7 02-Aug-2003
02 4 03-Aug-2003
..
..

can I write sql so that the data will be display in
crystal report in the following format:

id 1-Aug 2-Aug 3-Aug.......31-Aug
---------------------------------------------
01 5 2 6 .......8
02 2 7 4 .......
..
..

Thank you