Email + Reporting Services = Success
by B.Russell on Aug.07, 2007, under SQL Server
We recently released our latest version of our Web software here at work, which meant I’ve had some free time to learn more of the Advance features of Reporting Services 2005. One thing I wanted to check out was the subscription service. While playing with it I noticed that you could setup a schedule to have a report auto generated and then emailed to whom ever you choose.
The options available was a full To:, CC:, BCC:, Subject:, and Message: fields. Immediately I seen one of my most demanding tasks of running a custom monthly report and emailing it to the CEOs become one less thing on my plate. Long story short, the first of August the schedule fired off the auto generated report to the CEOs and CC’d me and my boss. It worked like a champ. I even told it to export it as a Adobe Acrobat format. I immediately received an email from one of the CEOs giving me praise for remembering it on time when he hadn’t and even taking the time to lay it out nice and neat in PDF.
It’s a shame he doesn’t know I let the server do all my work and I took credit, but isn’t that how it’s suppose to be =p ?
So if you haven’t had a chance to explore the capabilities of the Auto scheduler and Email functionality of Reporting Services, maybe you should. It could save some time on your demanding plate and bring a little more praise from your co-workers.
