Need some reporting help

• douglas.dawson

  Grasshopper

  Points: 12

  More actions

  October 28, 2009 at 12:13 pm

  #216793

  Hello all!

  I am stuck on this one. I'm trying to replicate a report for a user. The report looks like this:

  Model Type, Model Number, Registered Units for 2007, Registered Units for 2008, Registered Units for 2009, Total Registered Units

  At the end of a model type, there are totals for each year across all model numbers.

  I wrote a query to gather the data, but the data looks like this:

  Model Type, Model Number, Registration Year, Number Registered

  Any idea how I can make this work? Thanks!

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  October 28, 2009 at 1:03 pm

  #1072006

  Hi douglas

  Have a look to this link:

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

  Greets

  Flo