August 7, 2013 at 3:11 am
Hello!
To deliver statistics to the business controllers in our company, I use both report manager for built reports that they trigger themselves by logging in, filling in the forms and retrieve the data in the way they want - PDF, excel or just viewing the data. Another way is the scheduled jobs in the agent that runs and uses the msdb..sp_send_dbmail to e-mail the results. The problem with this second option is that the output is plain text, very ugly and hard to use.
The solution I am looking for is to be able to trigger a Report Manager report from a stored procedure (that I schedule in the agent) and get the result from that report in excel format mailed to a specified recipient.
Any ideas?
August 8, 2013 at 10:00 am
Sounds like you want to set up some subscriptions in Reporting Services for these users. Then you can specify the schedule and the delivery file format as desired.
I'd do some Googling for "Reporting services 2008 subscription setup", there should be plenty of resources to get you going there. Then if you have a more specific question later, you can come back for targeted advice.
Cheers,
EJM
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply