Last post Jan 23, 2020 02:54 AM by Yongqing Yu
Jan 22, 2020 03:01 PM|johnjalani|LINK
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,
Jan 23, 2020 02:54 AM|Yongqing Yu|LINK
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