SQL Server Performance

Export to excel problem

Discussion in 'SQL Server Reporting Services' started by redearth, Apr 16, 2004.

  1. redearth New Member

    Hi All,
    When exporting to excel after publishing any one of my reports to a web document, I get a excel file that#%92s filled with what looks like headers and encrypted code or data. Not at all the target report.
    The same reports do fine with exporting to PDF, CSV, html, etc.
    I am running win 2000, excel 2000 and I am testing a 120-day evaluation version of SQL Server 2000 reporting services.
    Any help would be greatly appreciated,
    Thanks,
    Nathan

    Below is the mess of text that I exported from the bad excel file as a .txt file...



    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;
    "charset=""utf-8"""
    Content-Transfer-Encoding: base64
    Content-Location: file:///c:/Report.htm

    77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6eD0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6ZXhjZWwiIHhtbG5zPSJodHRwOi8vIHd3dy53My5vcmcvVFIvUkVDLWh0bWw0MCI+CjxoZWFkPgbW5zUmlnaHREZXRhaWwvPjx4OkRvTm90RGlzcGxheUdyaWRsaW5lcy8+PHg6UHJpbnQ+PHg6VmFsaWRQcmludGVySW5mby8+PHg6UGFwZXJTaXplSW5kZXg+MDwveDpQYXBlclNpemVJbmRleD48L3g6UHJpbnQ+PC94OldvcmtzaGVldE9wdGlvbnM+PC94OkV4Y2VsV29ya3NoZWV0PjwveDpFeGNlbFdvcmtzaGVldHM+PC94OkV4Y2VsV29ya2Jvb2s+PC94bWw+PC9oZWFkPgo8L2h0bWw+
    ------=_NextPart_01C35DB7.4B204430
    Content-Type: text/html
    Content-Transfer-Encoding: base64
    Content-Location: file:///c:/Sheet1.htm

    77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIHJpbnQ+PHg6VmFsaWRQcmludGVySW5mby8+PHg6UGFwZXJTaXplSW5kZXg+MDwveDpQYXBlclNpemVJbmRleD48L3g6UHJpbnQ+PC94OldvcmtzaGVldE9wdGlvbnM+PC94bWw+PC9oZWFkPgo8L2h0bWw+
    ------=_NextPart_01C35DB7.4B204430
    Content-Type: text/css
    Content-Transfer-Encoding: base64
    Content-Location: file:///c:/stylesheet.css
  2. satya Moderator

    I'm not sure why it errors, but can you check on levels of service pack on SQL & Excel.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. redearth New Member

    I am using excel 2000 9.0.6926 with SP3
    and SQL server 8.00.760 with SP3
    Everything is up to date... I just dont get it
  4. redearth New Member

    quote:Originally posted by redearth

    I am using excel 2000 9.0.6926 with SP3
    and SQL server 8.00.760 with SP3
    Everything is up to date... I just dont get it

    Im sorry its - SQL server 2000 (8.00.760 with SP3)
  5. gpl New Member

    Microsoft say that they have engineered RS to only work with Excel 2003 and above

    they hope to get it to work with 2000 in their first service pack

    Graham

Share This Page