ltannous
11th November 2002, 18:40
What do you use in the report layout or script to create a crosstab report. I would like to have the dates appear at the top of each report and the items appear to the left and quantities appearing under the proper dates.

eg

Item.........monday....tuesday....wednesday....thursday....friday
-------------------------------------------------------------------------
123.............100.........100............100................100...........100
456.............400.........400............400................400............400
789 ....................
234

morpheus
11th November 2002, 18:51
Try using "Multi columns" in Form 2, of Maintain Report Layouts.

ltannous
11th November 2002, 20:41
how do you create the layout where the date range is at the top of the report, and the details that correspond to the date line up with the proper colums?