reporting services - How to specify different from addresses for difference subscription recipients? -
i have ssrs report sent out different user groups based on business function. need subscription change address depending on report being sent to. example when report finance group should sent finance@example.com when procurement group should come procurementadmin@example.com.
presently report sent address configured in from
field of subscription settings.
i read in post somewhere once changing owner id in subscriptions table - did not change me.
is there way make address dynamic in ssrs subscription?
i'm using sql server , ssrs 2008 r2.
the simplest way create multiple subscriptions different addresses configured. if have enterprise or business intelligence edition of sql server there better way.
you can accomplish using data driven subscription. allows set of subscription options sql queries. you need enterprise or business intelligence edition of sql server in order use data driven subscriptions.
i'm assuming report takes parameter determine type of report (e.g. finance, procurement, etc.)
first go subscriptions section report , create new data-driven subscription:
you configure data source sql query return subscription information. note: doesn't have rely on tables in database can synthesize of values in select
statement if works you.
you use query similar of settings:
select 'finance' type, 'finance_report_people@example.com' rcptaddr, 'financeadmin@example.com' fromaddr union select 'procurement', 'procurement_report_people@example.com', 'procurementadmin@example.com'
then next couple of screens allow use values determined query set various options subscription. in case set parameter value type
field, to
value use rcptaddr
field, , set field fromaddr
.
in way can configure dynamic subscriptions have different recipients, reply addresses, addresses, subjects, etc. based on parameter value you're passing report.