Sql Server 2008 Reporting Services email on the fly solution

Question

To all,

I have noticed that other reporting tools allow you the option, at the time of running a report from the web interface, to either have it rendered to the browser or allow you to enter an email address have have the report sent to that address. This would be helpful for long running reports or reports that are fairly large.

My question is whether this can be done with the existing sql server 2008 report server toolset or if there are third part solutions available?

Thanks.

--sean

Answer 1

You can setup a subscription on a report which will email it too you once or at regular intervals.

This Link give you more info. Be aware that if you want data driven subscriptions you need enterprise sql server.

Answer 2

I don't think that what you are wanting to do is possible out of the box.

This may seem like overkill for your situation, however, I have worked for a client who wanted some custom features like this. Given that Report Manager is so inflexible out of the box, we wrote a new front end leveraging the Reporting Services Service. We could then write our own extended capabilities right into the new viewer.

This link describes it a bit more.

http://msdn.microsoft.com/en-us/library/ms159218.aspx