Prev: Importing Access 2007 Reports
Next: bar graph not sorting ascending
From: nicholl74 on 26 Jun 2008 15:48
Hi

Im trying to use Reporting Services to render reports without using
subscriptions

This can be achieved by calling the Render method in the
ReportExecutionService web

service. It returns a byte array representing whatever export format you
selected, which you can then do what you want with. So far so good.

I can write the bytes out to a file and then using automation send the
report out as an email attachment

BUT

I now want to write the bytes out directly to the email body. How do I do
that?

I can turn the bytes into MHTML format but I can seem to get the mial
message to recognise it

I get an output like this



MIME-Version: 1.0

Content-Type: multipart/related;

boundary="----=_NextPart_01C35DB7.4B204430"

X-MSSQLRS-ProducerVersion: V9.00.3042.00

This is a multi-part message in MIME format.

------=_NextPart_01C35DB7.4B204430

Content-Disposition: inline;

filename="Daily Stats [All Territories] Report"

Content-Type: text/html;

name="Daily Stats [All Territories] Report";

charset="utf-8"

Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMDEgVHJhbnNpdGlvbmFs

Ly9FTiI+DQo8aHRtbD4NCjxoZWFkPg0KPHRpdGxlPg0KRGFpbHkgU3RhdHMgW0FsbCBUZXJyaXRv

cmllc10gUmVwb3J0DQo8L3RpdGxlPg0KPE1FVEEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBj

b250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPE1FVEEgaHR0cC1lcXVpdj0iQ29u

dGVudC1TdHlsZS1UeXBlIiBjb250ZW50PSJ0ZXh0L2NzcyI+DQo8TUVUQSBodHRwLWVxdWl2PSJD

b250ZW50LVNjcmlwdC1UeXBlIiBjb250ZW50PSJ0ZXh0L2phdmFzY3JpcHQiPg0KPE1FVEEgSFRU

UC1FUVVJVj0iTG9jYXRpb24iIENPTlRFTlQ9Imh0dHA6Ly9kb2xseS9SZXBvcnRTZXJ2ZXI/JTJm

Um9uYW4lMmZEYWlseStTdGF0cytSZXBvcnQlMmZEYWlseStTdGF0cyslNWJBbGwrVGVycml0b3Jp

ZXMlNWQrUmVwb3J0Ij48TUVUQSBIVFRQLUVRVUlWPSJVcmkiIENPTlRFTlQ9Imh0dHA6Ly9kb2xs

eS9SZXBvcnRTZXJ2ZXI/JTJmUm9uYW4lMmZEYWlseStTdGF0cytSZXBvcnQlMmZEYWlseStTdGF0

cyslNWJBbGwrVGVycml0b3JpZXMlNWQrUmVwb3J0Ij48TUVUQSBIVFRQLUVRVUlWPSJMYXN0LU1v

ZGlmaWVkIiBDT05URU5UPSIwNi8yNi8yMDA4IDExOjM2OjA4Ij48TUVUQSBOQU1FPSJHZW5lcmF0



 | 
Pages: 1
Prev: Importing Access 2007 Reports
Next: bar graph not sorting ascending