Crosstab With Weeks as Columns

[fdsouth]

I am trying to pull data from a table that has production volumes by date. What I want to do is create a crosstab with the different operations as rows and consecutive weeks (beginning Jan 1, 2007) as the columns. For example:


Seq Wk1 Wk2 Wk3 Wk4...
100 50 75 80 90
200 50 75 80 90
300 50 75 80 90
400 50 75 80 90

Sum 200 300 320 360

Any suggestions? I am having quite an issue with this seemingly simple idea. I can create the rows and details. The main problem I am having is creating the columns grouped by week (instead of by day which is how the records are stored in the table).

 

[IdoMillet]

In the CrossTab expert, assuming the date field in already a row or column, click the 'Group Options...' button and change the for each option to 'for each week'.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[fdsouth]

Thanks. That did it. I knew it had to be something pretty simple.