2012年8月30日 下午 04:10
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.
2012年8月30日 下午 05:32
You will want to use the data driven subscriptions feature, or write custom c# app or SSIS package to export & email reports.
Andrew Sears, T4G Limited, http://www.performancepointing.com
- 已提議為解答 Samay Shrivastava 2012年8月31日 下午 01:52
2012年9月1日 上午 07:23
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.
2012年9月2日 下午 10:23版主
Thanks for your posting. Please read these blogs, these will help you how data driven subscription help you to resolve your problem
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.
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.