How to design this report

[Huayang]

in my table there are the following fields:

OrderNo, Desc, StyleNo, Color, Size, Qty, DelDate

the field "Size" possible value is:

1) XS S M L XL XXL
2) 6M 9M 12M 15M 18M 2A 3A 4A 5A 6A 8A 10A 12A 14A 16A 18A
3) 0 1 2 3 4 5 6 7 8 10 12 14 16 18 25 26 27 28 29 30 31 32 33 34 36 38 40
42 44


I want to print the report format that like this:


Style No.: PB2673-050-645
Description: BABY's 60% COTTON, 40% POLY KNITTING JACKET
----------------------------------------------------------------------------
-------------------------
Order No. Color\Size XS M XL 9M 12M 2A 3A 6A
TOTAL Del.Date
----------------------------------------------------------------------------
-------------------------
2206049 086 LIGHT BULE 52 10 10 12 22 10 10 10 136
06-03-30
2206390 086 LIGHT BULE 2 14 14 20 16 18 10 16 110
06-03-30
____________________________________________________________________________
_________________________
TOTAL 54 24 24 32 38 28 20 26 246


Every time the Size is diffrent in the report according to Order. the mean
is that the head line is dynamic. How to design this format report? how to
put the Size's value at the report's head line? Thanks.

 

[Duane Hookom]

There is a report in the Crosstab.MDB at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4 which has dynamic column
headings.