Graphing Table Data

• Tom Frost-122702

  SSC Veteran

  Points: 250

  More actions

  November 5, 2004 at 5:31 am

  #361389

  I want to set up a job that I can run out of SQL Agent which will run a query against a table and plot the results graphically.  Performint the query is no problem but the presentation part I've been struggling with.

  Is there a way to perform this programtically into Excel and Reporting Services without any manual intervention?  Looking to plot historgram and bar charts of data.

  If anyone has done this and can recommend a link , article or provide basic tips on how to perform would be great.

  Thanks

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  November 5, 2004 at 1:38 pm

  #529160

  DTS supports EXCEL as an output that you can put a transformation task into:

  select ... from result table

  OR

  exec ResultProducingProc

  Now just go find an excel forum for how to create graph/automate/display using that tool.

  (you can always exec a dos statement in a DTS step if you need to.)