wish helps you This takes me back to my old job where I wrote a solution to a problem using data-driven subscriptions on our SQL Server 2005 Enterprise development box and then discovered to my dismay that our customer only had Standard. I bookmarked this post at the time and it looked very promising, but I ended up moving jobs before I had a chance to implement it.
fixed the issue. Will look into that further If you are referring to the "Comment" field that you define when creating the data driven subscription then the only parameters that seem to be available are @ReportName and @ExecutionTime. The subscription is not aware of the data driven command results :(
will be helpful for those in need Issue was the order in which the alternate active mappings were set up. The URL embedded was the one for the default zone. Switched the domain URL to the default zone and we're rolling now.
SSRS Data Driven Subscriptions: save file to location AND send email
this one helps. I want SSRS to produce a file to a specific location and send emails out to a list of recipients. The need to archive a series of reports is something everyone is interested in, we want to avoid sending out a lot of attachments, and the notification of a newly produced report adds value as well. Unfortunately, it seems I can only accomplish one or the other of these things with subscriptions. , Short Answer Using one subscription you cannot do that.
SSRS data driven subscriptions for valid email addresses
this will help Based on your comment response I believe I have a solution. You will need to add some error checking in your where clause to filter out anybody with erroneous or NULL emails. Alternatively, you could have a case statement that tries to detect and correct bad emails and replace NULLS with a junk local email address. SSRS won't fail if it can't deliver the email but apparently it will fail if you don't have an email in your dataset for data driven subscription. It's going to be up to you to make sure this doesn't happen!