November 5, 2004 at 5:33 am
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
November 8, 2004 at 8:00 am
This was removed by the editor as SPAM
November 9, 2004 at 2:26 pm
I accomplished this task by using the Reporting Services data driven subscription feature. High level steps include:
1. Create your report(even if it just consists of a graph) using the report designer and deploy the report.
2. Create the table that will hold your options for the report (ie. file name, path or email for delivery, format, etc.)
3. Then set up a data driven subscription for the report.
There are lots of articles on how to manage these steps. Search dbforums or devx for starters.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply