none
Export to xls loses date format RRS feed

  • Question

  • Hi,

    I am using the report viewer in VS 2008 and have created a report with dates using the format dd/MM/yyyy and the language on the textbox is set to English.

    When I view the report or export it to PDF the dates are shown as expected "08/04/2008", if I export to xls, I get a warning "File Error some number formats may have been lost" and the dates are shown as "39546".

    Can anybody help as to what I am missing.

    Regards.
    Tuesday, December 16, 2008 10:57 AM

Answers

  • Hello,

    Any time you see an error dialog like that after opening an XLS generated by SSRS it is a bug.  We don't ever want our XLS output to cause those kinds of errors in Excel.

    Can you please file this at http://connect.microsoft.com?

    Many thanks,
    Chris
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, December 17, 2008 2:51 AM

All replies

  • Hello,

    Any time you see an error dialog like that after opening an XLS generated by SSRS it is a bug.  We don't ever want our XLS output to cause those kinds of errors in Excel.

    Can you please file this at http://connect.microsoft.com?

    Many thanks,
    Chris
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, December 17, 2008 2:51 AM
  • Thanks Chris,

    Will do.
    Thursday, December 18, 2008 7:31 PM