August 4, 2017 at 11:46 am
I have a SSRS report. I have setup a subscription to the for the report which is rendered to Excel and ends up as an attachment in the email.
I also have included text in the delivery options comment box to be part of the email when sent.
is it possible to add an image in the comment box, (such as a company Logo) I have searched online and have not found any way of doing this.
Thank you
George
August 9, 2017 at 6:40 pm
georgeg 69122 - Friday, August 4, 2017 11:46 AMI have a SSRS report. I have setup a subscription to the for the report which is rendered to Excel and ends up as an attachment in the email.
I also have included text in the delivery options comment box to be part of the email when sent.
is it possible to add an image in the comment box, (such as a company Logo) I have searched online and have not found any way of doing this.
Thank youGeorge
I couldn't find anything either. So I played around with the Web Service and it doesn't look like it. The ParameterValues properties for the settings on that subscription page are strings.
The only way I can think of to do it would be something where you manage your own details for subscriptions and schedules, dump the file out to a file share, have your own polling of a subscription table, pick up the file, create the email with the logo, etc.
Sue
August 10, 2017 at 2:04 am
Is it just for a specific subscription, or all of them? We have it set up on Exchange so that all emails sent our SSRS service account have specific text added to the bottom, which does include an image.
Not sure if you can, but you may even be able to set up rules so that the footer is only added for a specific account, when it has a certain header.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 10, 2017 at 10:38 am
OK
I didn't think it was possible. since the comment box is text only. we use a third party email hosting service using office365 exchange and our SSRS is connects to exchange server to relay the emails. its not a big deal, for now we will just use the comment box to add additional text to the email.
thanks for the reply
August 10, 2017 at 12:27 pm
If you have Enterprise Edition you could try setting up a data-driven subscription. You would then create a query that pulls the necessary information from SQL Server - where you can define the comment column and embed an image file (maybe). You would have to insure that you embedded the data appropriately and make sure you are sending in HTML format to render the image data.
Not sure if that would work - but something to try
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply