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...

[Mark Gambo]

You will need to setup a cross tab report

[shakti5385]

Insert a Cross-Tab by choosing Cross-Tab from the Insert menu, or click the Insert Cross-Tab button on the Insert toolbar .This should present the Cross-Tab Expert dialog.

[skinpower]

I played with cross-tab and got a similar result that I wanted.

Two things to improve;
1. getting FirstName and LastName in one row
2. totalling # of "P" code for each person

But other than that, I am ok.
Thank You Mark and Sharkti.