October 16, 2013 at 4:26 pm
Hi There,
This is really odd.
If we run a report and display it to the screen dates are correct dd/mm/yyyy. However if we then chose the option to download into excel the resulting column goes American mm/dd/yyyy.
I have checked the langauge settings on the report server and on the internet setting on the report server. Both being English Australia
Our developer has checked the date format on the report and it's correct.
Now to make it stranger. If our developer runs the report in visual studio and then downloads to excel the date formats remain correct.
Any ideas ? Anyone seen anything like this before ?
Thanks
Corinne
October 17, 2013 at 1:21 am
Have you checked the locale on the client PC (where the excel file is being opened)?
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
October 17, 2013 at 3:42 pm
Yes I did check the local PC.
We ended up finding the issue yesterday in the reportserver.config you need to change the CSV formatting as below. Otiginally it was set to False changed it to true and all good now.
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<Configuration>
<DeviceInfo>
<ExcelMode>True</ExcelMode>
</DeviceInfo>
</Configuration>
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply