question

wolfeste avatar image
wolfeste asked

Create Data Driven Subscription for Subject line

I am running SQL 2012 Standard and would like to pass parameter values from my report to the subject line of an email getting sent out. I know that it is not supported in the standard edition but I have seen some workarounds for SSRS 2005 floating around. Anyone know a way to do this in SSRS 2012?
data-driven-subscriptions
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
SQLGoooRooo avatar image
SQLGoooRooo answered
Maybe try creating a job. Send the job notification to an Operator or to specified recipients. Put code like this into your job maybe: exec master.dbo.sp_NotifyProc ‘ xxx@localserver.com’,’ yyy@localserver.com’,'Subject Line Info Here’,'Body text info here'
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.