I have a view created in SQL server 2000, which contains (recItemNum, recMonth, recYear, recManagerNum, recCustNum)
recMonth holds a numeric value 1-12 (for the month)
and recYear holds 2003-2004
now I want to build a report so it looks like this:
recMonth 1-12
then have recQauntity show up under the correct month
header:
1 2 3 4 5 ..... 12
details:
(value of recQuantity for month = 1) (value of recQuantity for month = 2) ...........
how can I do this...please forgive me if this makes no sense.