Showing posts with label attached. Show all posts
Showing posts with label attached. Show all posts

Monday, March 19, 2012

Email format for Reporting Services

Hi, this question is related to Reporting Services on SQL Server 2000. When creating a report and setting it to send via email as an attached excel spreadsheet, the email is in the format HTML. Does anyone know if it possible to default this format to something else like Rich Text. I have a feeling that this might involve a change to the RSEmailDPConfiguration within the RSReportServer.config file but am not sure which tag needs changing or adding.

Any help/suggestions greatfully received.According to documentation:

rsreportserver.config

EmbeddedRenderFormats

Specifies the rendering format used to encapsulate a report within the body

of an e-mail message. Images within the report are subsequently embedded within

the report. Valid values are MHTML and HTML4.0.

Does not look like you'll get Rich Text in an email without some custom code.

cheers,
Andrew|||

RTF is not supported by out-of-the-box RS. Theoretically you can write your own renderer but it's a difficult task, plus then you'll need to write custom delivery provider to support it as well. Support for RTF is in the wish list for the next RS version.

|||Thanks for both of your comments. I had a feelling it might be a custom option.

Sunday, March 11, 2012

EMail Delivery Format Problems

I have installed RS with SP1. I can send e-mails with reports attached to
it, but when I open the attachment I only see garbage, no matter what kind
of format I select (excel, pdf, etc.).
Any ideas?. Should I change something into the configuration files?
Thanks,
DanielYou might be running into the encoding issue. You can either install this
hotfix:
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774 (Ignore the
fact that it is about Lotus, the real issue is an encoding issue)
Or you can install SP2:
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel M" <dmongeb@.hotmail.com> wrote in message
news:u$JutcWYFHA.3164@.TK2MSFTNGP09.phx.gbl...
>I have installed RS with SP1. I can send e-mails with reports attached to
>it, but when I open the attachment I only see garbage, no matter what kind
>of format I select (excel, pdf, etc.).
> Any ideas?. Should I change something into the configuration files?
> Thanks,
> Daniel
>