Retain Date Format when Exporting to Excel from SSRS 2005
When exporting a report from Sql Server Reporting Services 2005, if the dates need to be formatted but retain date type on export, do the following:
1. Do not convert the data while fetching from SQL server to varchar/nvarchar.
(Keep it as a date)
2. In the report designer, go to the text box properties by pressing F4 (do not right click to select the properties).
3. Select textbox language as English (United States). (or whatever is appropriate)
4. Right click on the text box and select 'Properties', format tab, enter the format required in the format box (ie 'MM/dd/yyyy').
Now it will display with the correct format, but export as a date.
Created By: amos 2/25/2011 11:32:35 AM
Updated: 3/27/2019 2:46:21 AM