5 Replies Latest reply: Mar 16, 2011 10:05 AM by Mark Boomer RSS

    Is it possible to create a cross table from a SQL server table

      I'd like to be able to display something like this

       

      NameJanFebMarAprMayJunJulAugSepOctNovDec
      Name120910000000000
      Name2251020000000000
      Name 2301130000000000
      Monthly Totals753060000000000
      Yearly Total165


      I've seen how to create a cross table using the wizard in the Edit Script dialog but this looks like it needs the data already formatted.

      Can I create either a chart or table view like this if the data not already formatted and exists is a SQL server table.

      I am using the personal edition.

      Any advice appreciated