question

RhondaFletcher-4850 avatar image
0 Votes"
RhondaFletcher-4850 asked RhondaFletcher-4850 commented

SSRS put Report Parameters with default values in body of email

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @RhondaFletcher-4850
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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered RhondaFletcher-4850 commented

Hi @RhondaFletcher-4850

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.


image.png (5.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,

I should have noted that I did try this, but it did not work. It did not recognize the parameter values, it just displayed the text exactly as it was typed. However, thank you for answering!

1 Vote 1 ·