CR Design, Format

[skinpower]

Hi, here is where I am stuck. I want to creat CR report from VS2005 (CR is bundled one with VS2005) using SQL 2005 express.
I want to retriev three fields from three different tables.
Name, Code and date. Dates will be decided by user (Start Date and End date)
Each name will have a code on each day.

I want it like this

---------- 1/23/06... 1/24/06...1/25/06
John Smith ....P............ P...........S
Ed Reed ........S............N ..........O
James Bond....P.............P .......... P

Instead of

..Name............code........Date
John Smith........ P........1/23/06
Ed Reed............ S........ 1/23/06
James Bond....... P........ 1/23/06
John Smith........ P........ 1/24/06
Ed Reed............ N....... 1/24/06
James Bond........P....... 1/24/06
John Smith........ P....... 1/25/06
Ed Reed............ P....... 1/25/06
James Bond....... P....... 1/25/06


Is this possible in CR? if it is, how to make it? Thanks a bunch in advance...