I have a report that displays data for a specified date. The report runs daily and emails a copy to the recipients. The default subject for the email is "@ReportName was executed at @ExecutionTime." Rather than include the execution date, I want to include the date of the report data, which is available in a parameter called @date.
How can I include a report parameter's value in the subject line of the subscription email?
I'd recommend looking into data-driven subscriptions. Basically they allow you to write a query to set your parameter value(s) and define additional columns that can be used for subject line, message body, etc. Here's one helpful resource:
Also, I should point out that data-driven subscriptions are only available on certain versions of SQL Server (Evaluation, Developer, Enterprise).
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments