locked
SSRS export to excel and retain data format RRS feed

  • Question

  • User-1132163444 posted

    Good day,

    may i ask if there is a way to export SSRS reports to Excel and still retain the correct data type?
    ex. Date field when exported to excel should still be a date field, same with decimal or integers.

    maybe a SSRS event/function that is called only if a report is exported excel and inside is a code that will render the fields data type properly?

    I hope someone can enlighten me with this,

    Thanks

    Wednesday, January 22, 2020 3:01 PM

All replies

  • User665608656 posted

    Hi johnjalani,

    Based on my research , it seems by design ,whatever format  in report ,when export to excel ,it could be changed to custom or general .

    You could change the cell format manually in excel via right click->Format Cells -> Number ->Date.

    Or you could export as csv file , it could remain your format.

    keep date cell format in excel after export from SSRS 2005

    Best Regards,

    YongQing.

    Thursday, January 23, 2020 2:54 AM