SSRS export to excel and retain data format RSS

• • Reply
  johnjalani

  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

  JFRBPH12™
  
  It's more fun in the Philippines :)
  http://www.philippinetourismusa.com/
• • Reply
  Yongqing Yu

  Contributor

  3710 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.

  MSDN Community Support
  
  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.