Post reply

Send email to email field in report in 2008 Std Edition

  • July 27, 2010 at 9:52 am

    #235699

    I need to run a report and send the content of specific records to the email address on that line.

    For example.

    If the report was related to Tasks To Do Today, the report may have 100 rows, and the tasks relate to 5 people (so 20 tasks each)

    Each of these 5 people need to receive the report just containing their data.

    One way I guess would be to create a normal subscription then run a query in a cursor, to change the parameter of 'task owner' to be the current task owner, and somehow the email To then execute the report.

    But how is this done in standard edition, or is there a better approach to this without upgrading to Enterprise edition?

    Thanks

  • July 27, 2010 at 11:30 am

    #1198868

    Probably the easiest way would be for your to spring to Enterprise edition so that you have access to data driven subscriptions. Failing that however you should be able to create a subscription and then modify it via the WebService. Here's a link that details managing the subscriptions but only from a very high level, you'd need to dig into it a bit deeper... http://www.codeproject.com/KB/reporting-services/DynamicSSRSSubscriptions.aspx

    Also, I would imagine it could be done from TSQL and or an SSIS task as well.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply