Subscriptions

Question

Hi,

I'm using subscriptions in SSRS to send out reports to 3rd parties who don't have access to our intranet.

Rather than maintaining the To, Cc on the report page is it possible to edit this in a SQL table?

As the report list builds it will be easier to maintain this in bulk via SQL rather than manually changing each report.

Regards,

Lee

Answer 1

Hi there,

You will want to use the data driven subscriptions feature, or write custom c# app or SSIS package to export & email reports.

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

cheers,

Andrew

---

Andrew Sears, T4G Limited, http://www.performancepointing.com

Answer 2

Hi Andrew,

Unfortunately the reports are not standard.   The source being many multi-dim cubes. 

 We have seperate RDL's.  I don't see how data driven subs/c# will help when I can simply set the distrubtion/render type from within SSRS.

As a non-dev this suits me to be honest.  The only issue I find is that maintaining the emails will provide to be problematic.

Unless I'm missing something.

Lee

Answer 3

Hi There

Thanks for your posting. Please read these blogs, these will help you how data driven subscription help you to resolve your problem

http://blogs.devhorizon.com/reza/2008/10/26/ssrsdata-driven-subscriptions-in-integrated-mode-part-1/

http://blogs.devhorizon.com/reza/2008/10/26/ssrsdata-driven-subscriptions-in-integrated-mode-part-2/

http://www.databasejournal.com/features/mssql/data-driven-subscription-in-ssrs-2008-r2.html

Basically, you can create a SQL table with all the setting for your subscription, email address, file type etc. and use an SQL query to get these addresses and sent an email to all your users. You can create as many data driven subscription as you would like. You do not need to main these  email address on every report. Just insert these email address in the table and use the SQL query to get it. I hope this will help.

Many Thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.