Data Driven subscription in html with custom Reply-to and images

Question

I am working on a solution for Power BI Report Server (on prem-no service).

My Requirement is to Deliver SSRS status reports to a set of stakeholders stored in a SQL Database, and have those emails Appear to be from the Project Managers of various projects (addresses also in db)  The Email body should be in HTML and include images.

Initially, the right solution appeared to be to just create a Data-driven subscription in MHTML format, and replace the Reply-to with the Project Manager(reply-to)  address from the Data-driven query as well as the recipients, subject, etc.

The issue with this approach was that the requestor insists that the “display name” be custom also, like “Joe Project Manager joemanage@company.com” , However this does not seem possible as even when specifying reply-to as “Joe Project Manager joemanage@company.com”

My understanding is that MHTML cannot be used as the body of an email without completely converting it to html, and most of the solutions I have seen use C# for that and my skills in c# are very minimal.

In order to get the display names to show up, I Changed the data-driven subscription from MHTML to HTML 4.0 (after adding that type to the report server configuration)  and from EMAIL to Filesystem.

Then another sql Agent job step (SQL Procedure) picks up the files and (removes some special characters) then bulk loads them and sends the emails.  This solution allows me to fill in the display name so the emails come as the appropriate “Joe Project Manager” rather than the address saved on the report server config.

This approach is working great EXCEPT – Images are not rendered in HTML 4.0 SSRS report emails since the links to the images are not correct.

 

Can anyone provide any further guidance on How I might get reports with images emailed with a custom reply to?

Answer 1

Hi @sean denney

This seems to be designed into a development issue, I don't know much about this part. But from what I've searched, it's possible that it's a permissions issue. I found these links for you, hope it helps.

[https://stackoverflow.com/questions/47056364/ssrs-external-image-not-rendering-on-html-report

[https://stackoverflow.com/questions/47219831/ssrs-image-not-rendering-on-html-4-0-reportunauthorization

Best regards,

Aniya