Cross Tab columns for quantities

[cinbh]

I am trying to create a report that shows the rows of product with columns of Date and then under the ShipDate an Order Qty column then a Committed Qty column for that date should look like:
5/13/04 5/20/04 5/27/04
Ord Comm Ord Comm Ord Comm
Poinsettia Marble 100 50 75 100 82 82

Row: Fieldname Descriptor
Column: Fieldnames Shipweek, Odordqty, Odcommqty
Obviously I can't use the qty fields as the columns in the cross-tab generator as it just puts in numbers, any quick ideas for a dabbler here?

Thank you in advance.
Cin

We use VFP 8.0 with Crystal 8.5

 

[lbass]

I don't think you can get side by side values in CR 8.5 unless you create a manual crosstab.

-LB