Tuesday, February 19, 2008

format date excel export reporting services - Google Search


Not a lot of results on this one... so I figured it out myself.

Instead of formatting just the field, you need to format the entire column in order to retain the date format in Reporting Services Excel export.

Hope this helps someone else.

format date excel export reporting services - Google Search

2 comments:

Unknown said...

Hi.
How did you solve the date-format-issue when export from Reporting Services to excel?

Andrew said...

Format the entire column (header, footer, details) with the proper format.