Formatting output in crystal 1

[olitvinov]

I'm looking for a good idea as to how to approach this problem in a best way.
I'm using Crystal XI.
Please look at following input table and desired output for report. (Copy and paste to notepad for easier reading)

Input (my input table):

Code DefectCount WeekNumber WeekStartDate
AA 20 5 2006-01-30
AA 20 6 2006-02-06
AA 20 7 2006-02-13
AA 20 8 2006-02-20
BB 22 5 2006-01-30
BB 22 6 2006-02-06
BB 22 7 2006-02-13
BB 22 8 2006-02-20
CC 24 5 2006-01-30
CC 24 6 2006-02-06
CC 24 7 2006-02-13
CC 24 8 2006-02-20

Desired Output layout:

Code 2006-01-30 2006-02-06 2006-02-13 2006-02-20 Total
AA 20 20 20 20 80
BB 22 22 22 22 88
CC 24 24 24 24 96
Total 66 66 66 66 264

Thanks, Oleg

 

[bdreed35]

A crosstab would work great for this.

Insert a new crosstab, use code as the row field, weekstartdate as the column field (grouping on each day), and defectcount as the summarized field.

~Brian