Data Driven Subscriptions in Reporting Services - Delivering Via Email

Reporting Services lets users subscribe to reports, but sometimes it would be easier to just send reports to a list of users based on a query, and that's exactly what you can with data driven subscriptions. In this lesson Devin shows you how to set up the query and how to customize the message - whether to send a link or the full report, what format, and more.

Devin (MCTS) is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business...

Charlie Bruno on 2/18/2010

Informative. Good job.

M S Rama Raju on 2/22/2010

no

Jason Thurston on 4/5/2010

The video quality wasn't very good.

6361C28F3B on 4/5/2010

Why didn't PDF's work?

Babita Das on 4/5/2010

Excellent one .

Akber Ali on 4/6/2010

video was good, but always it has very poor quality of rendering the video. Please use different technology.

Mark on 4/6/2010

I really want to do this but I cannot get subscriptions to work on my systems

on 4/6/2010

Thank you. Tis is very helpful.

Rod on 4/6/2010

What version of SQL Server Reporting Services does this apply to?

Bill Portman on 4/6/2010

This will be very helpful!

Talha on 4/6/2010

Bravo

Vincent DANIEL on 4/6/2010

Interesting !

Calvin Johnson on 4/6/2010

Very Good!

Devin Knight on 4/7/2010

This is using SQL Server 2008 developer edition/enterprise

Cosmin Tornea on 4/9/2010

excelent

ricardoacaraujo@hotmail.com on 4/27/2010

Muito bom

Steve Culshaw on 5/29/2010

Good content, but video quality bit blurry

Prashant on 8/10/2010

Nice presentation

mohd mudassir ali on 11/12/2010

nice one. i had seen in the class before

Amy Neumann on 1/18/2011

Timing on this video couldn't have been more perfect. Let's say I want to run a report and then once it comes up, have the option to email it to an email address in the database. Is this possible?

Jay Stobbe on 1/18/2011

Blurry

Tom Hamilton on 1/18/2011

Really great thanks all

Kasey Wheeler on 1/18/2011

Good video

Phil Gardner on 1/18/2011

Great presentation. Very informative and easy to follow.

Dallas on 1/18/2011

very helpful! good work :)

Ira Davis on 1/18/2011

Why not show actually retrieving email addresses from active directory group?

glyn on 1/19/2011

Good, however delivery was too fast to take is fully onboard and graphics a tad too small, otherwise great - thanks.

Team FAB on 1/19/2011

I thought you set it to PDF as well. A bug?

Ludwig on 1/19/2011

good job guys

Aruna on 1/19/2011

I get stream not found error message. If this has been updated recently, please check to see if the link has been broken to view the video.

Marcelo Marim on 1/20/2011

Very well done.

Diana Dee on 1/21/2011

The print was way too small to see.

Bridget on 1/24/2011

Excellent. If the font was bigger throughout then it would have been better yet.

Maurice Ivory on 5/10/2011

This was really great, I would like to learn more about sql share

Dinesh on 7/5/2011

dfd

Olu on 7/7/2011

I really learnt something new today! This was my first look at subscription driven Reporting Services

Pankaj on 7/12/2011

excellent