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
eg
Item.........monday....tuesday....wednesday....thursday....friday
-------------------------------------------------------------------------
123.............100.........100............100................100...........100
456.............400.........400............400................400............400
789 ....................
234