Post reply

SSRS export to CSV French and Spanish Characters

  • May 18, 2016 at 6:47 am

    #307829

    I have a report which has french "Français" and Spanish "Español" words. When I export it to CSV these words character "ç" and "ñ" does not render correctly. However, with excel it is rendered correctly.

    I want to understand this is limitation with SSRS export to CSV or can be corrected by changing report server configuration.

    Thanks,

  • 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 3 posts - 1 through 2 (of 2 total)

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