SSRS put Report Parameters with default values in body of email

Rhonda 26 Reputation points
2022-05-16T19:10:02.58+00:00

Hello,

I have created a report with a Start Date and End Date parameter where both are set to default parameters. This is working. However, I also had a request to put those same parameters in the body of the email when using subscriptions. Basically, the body of the email should say, "Attached is the Monthly Reconciliation Report from @StartDate to @EndDate." How can I do that? Thank you!

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,631 Reputation points
    2022-05-17T06:20:34.75+00:00

    Hi @Rhonda
    You can add text in Subject to modify the default subject; add text in Comment to add content to the body of email.
    But unfortunately the subscription doesn't seem to recognize the default parameter values, this is by design.
    As far as I know, you can only use @ReportName and @ExecutionTime variables in Subject.

    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Isabellaz-1451 3,616 Reputation points
    2022-05-17T03:15:36.77+00:00

    Hi @Rhonda

    You can edit your description on the comment textbox
    202573-image.png

    Best Regards,
    Isabella


    If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.