Post reply

SSRS export to CSV French and Spanish Characters

  • May 18, 2016 at 7:28 am

    #1879871

    This is because SSRS, by default, doesn't export CSV's in unicode, but in ASCII.

    You'll need to locate Report Services Configuration file, and then amend/add the render type. For example, on SQL 2012, the path will be something like: \Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServerrsreportserver.config

    Locate the Render node, and add the following (you could amend the CSV format if you wish, i've gone for having ASCII and unicode Render options for this example)

    <Extension Name="CSV - Unicode" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">

    <OverrideNames>

    <Name Language="en-us"> CSV - Unicode</Name>

    <Name Language="en-gb"> CSV - Unicode</Name>

    </OverrideNames>

    <Configuration>

    <DeviceInfo>

    <Encoding>UTF-8</Encoding>

    </DeviceInfo>

    </Configuration>

    </Extension>

    That'll then add a new render type when exporting in your subscriptions and when viewing the report on the SSRS web interface.

    Hope that helps.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • May 20, 2016 at 1:06 am

    #1880432

    Thanks! Thom.

    I have made the changes and it worked perfectly.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply