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