Issue in exporting to Excel

  • We are facing an issue when exporting the report output to an excel. Ouput looks like garbled characters in excel.PDF is fine. We are using Excel 9(Office 2000). Looks like,we need to use Excel 10 office 2002,3. Did any one faced this issue.

    Any one using MS reporting services with Excel (Office 2000

     

  • This was removed by the editor as SPAM

  • I just read in BOL that in order to export you have to be using the latest version of Office - XP 2002 or later, I believe. 

    I'm getting the same garbled result.

  • That's right.  The CLIENT needs office XP or later to export to Excel.  I got around this problem by setting up a subscription to email the Excel file to the user.

    Bryan

  • This issue apparently is going to be addressed in an upcoming (June/July) SP of Reporting Services.  See also in thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=108952

    This SP is intended to give export support to versions back to Excel 97, by exporting in binary interchange format.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply