question

AndreyKucherovsky-9345 avatar image
0 Votes"
AndreyKucherovsky-9345 asked Joyzhao-MSFT edited

SSRS Customize From field

Hello everybody!





I have configured SSRS and mail settings to send letter for subscriptions.

So SSRS successfully sending letters now and everything fine there.



But users want to customize the From field.

Is it possible to set any another one mail account or display name in the From field for specified subscriptions?

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.

1 Answer

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

Hi @AndreyKucherovsky-9345 ,
If you are referring to changing the sender address while the subscription works then I think better would be if you run a SSIS package for calling a SSRS report.

When you schedule a report in reporting services it creates a job in the backend database (reportserverdb). You can call this job from an SSIS package and then export the results to a folder. Once in the folder you can use Send Mail Task in SSIS to send out the email. In SSIS you can change the From value to whatever you like which can be a variable based value depending on your tenant.

Have you been exposed to SSIS before? You could refer to the following links first. If it still cannot be resolved, I suggest you consult an SSIS expert.
Here are links:
https://social.msdn.microsoft.com/Forums/en-US/4b73f0c5-bdae-462c-846b-eaf4d5dc94a9/use-ssis-to-send-sql-server-report-as-email?forum=sqlreportingservices
https://social.msdn.microsoft.com/Forums/en-US/3a33a452-d518-4a5c-a751-80705be0edc8/trigger-the-subscription-report?forum=sqlreportingservices

You could also enable this feature through a custom code. However, since this situation is beyond my ability, you may wish to consider my first proposal.

Hope this helps.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
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.