SSRS Download into excel changes date format

  • 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

  • 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

  • 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