Problem exporting report to other format

Hi,

I have successfully created my first report. however when i tried to export the report to other format like excel, it doesn't work. and give me some funny codes

======================================
MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related;boundary="--=_NextPart_01C35DB7.4B204430"
This is a multi-part message in MIME format.
--=_NextPart_01C35DB7.4B204430
Content-Type: text/html;
Content-Transfer-Encoding: base64
Content-Location:file:///c:/Report.htm
77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb2[TRIMMED]=
--=_NextPart_01C35DB7.4B204430
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Location:file:///c:/Sheet1.htm

77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb2[TRIMMED]==
--=_NextPart_01C35DB7.4B204430
Content-Type: text/css
Content-Transfer-Encoding: base64
Content-Location:file:///c:/stylesheet.css

77u/Lnhscl8zewpwYWRkaW5nLWJvdHRvbTowcHQ7ZGlyZWN0aW9uOkxUUjt0ZXh0LWRlY29yYXRpb246Tm9uZTtmb250LXNpemU6MTBwdDtjb2xvcjp[TRIMMED]
--=_NextPart_01C35DB7.4B204430--
=====================================================

Anything that i need to set?

______________
Post trimmed by moderator SomeNewKid

Hi eeyore21
I run Office 2003 and XP with SRS SP2. So It may differ or not. But what I found was that Office2k3 allows you to right click( which brings up the context menu) and choose export to excel. This is totally diffrent than to select the export format for the Report Server Toolbar. If you want to export a SRS report you must use the SRS Toolbar and not the IE context menu. Context menu does strange things to the SRS formating and the way it gets exported. Sometimes it ( context menu) will work depending on the HTML rendered by SRS it is not to complex|||

Hi l0n3i200n ,
Yup, i used the SRS toolbatr to export to excel, but it doesn't give me the end result.
Another issue that i face is that when i export to pdf, it seems to break the report horizontally to serveral pages, instead of 1 page only.
Is there anywhere i can set this?

|||

Hi

I've had the same problem with PDF files, I read in one of the posts that you should set the Report Margins to the required size, however that didn't work for me. In the end I had to resize the controls to fit on a report(SRS Report Designer Page) set with margins the same as a A4 page. This made things better but didn't solve the problem completely.

|||

Thanks l0n3i200n,
I managed to export to excel file after installing service pack 2 for Reporting server.
I guess we have to make our report fit on a A4 page. :(

|||Good Evening Or Good Morning!
I have just "scrapped" the export capibilities to PDF!
PDF never renders anything useful in Thai, Korean, Laos, or Cambodian!
So I just make everyone and at times do it automatically to a TIFF!
The export to a TIFF never "burps"!
This may be of some help or not and -
Best Regards,