Pivot table type of report

• sunil sharma

  Valued Member

  Points: 59

  More actions

  September 30, 2005 at 5:03 am

  #168884

  is is possible to produce a pivot table type of report, the source data is

  Product Description Qty

  ProdA Descr1 Qty1

  ProdA Descr2 Qty2

  ProdA Descr2 Qty2

  ProdB Descr1 Qty4

  ProdB Descr2 Qty5

  ProdB Descr3 Qty6

  the report to look like this

  Description ProdA ProdB...etc.

  Decr1

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  September 30, 2005 at 5:45 am

  #594286

  It is.  Search here for rows to columns or PIVOT or ... + in SQL 2k5 it is by using PIVOT keyword....

   

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net