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
JFRBPH12™
It's more fun in the Philippines :)
http://www.philippinetourismusa.com/
Member
243 Points
566 Posts
SSRS export to excel and retain data format
Jan 22, 2020 03:01 PM|johnjalani|LINK
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
It's more fun in the Philippines :)
http://www.philippinetourismusa.com/
Contributor
3690 Points
1043 Posts
Re: SSRS export to excel and retain data format
Jan 23, 2020 02:54 AM|Yongqing Yu|LINK
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.
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.