none
MS REPORT BUILDER 3.0

    Question

  • Dear All,

    I'm using MS report 3.0 builder to generate some reports from Oracle database, I want to configure the rendering options when exporting to CSV to change the encoding to UTF-8. I googled a lot of topics and they all talk about changing the rsreportserver.config in sql server, but I'm using Oracle ? Is there any way to configure this?

    Thursday, January 23, 2014 11:39 PM

Answers

  • Hi InsaneDev,

    To use data from an Oracle database in our report, we must have a dataset that is based on a report data source of type Oracle. It means that when we use Oracle database as data source, then we can retrieve report data from an Oracle database. Though the data source is an Oracle database, the report design and render formats are still be depended on Report Builder tool.

    So if we want to change the encoding to UTF-8 when export the report to CSV format, we can solve this issue via modifying the rsreportserver.config as below:

    1. Please navigate to RSReportserver.config file: <drive:>\Program Files\Microsoft SQL Server\MSRS1111.MSSQLSERVER\Reporting Services\ReportServer \RSReportserver.config.
    2. Backup the RSReportserver.config file before we modify it, open the RSReportserver.config file with Notepad format.
    3. Find out the following line:
      <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
    4. Replace it with the following code block:
      <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
       <Configuration>
        <DeviceInfo>
                             <Encoding>UTF-8</Encoding>
        </DeviceInfo>
       </Configuration>
      </Extension>
    5. Save the file and restart the reporting service, and export the CSV file to see whether the issue is solved.


    For more information about CSV Device Information Settings, please see the following document:
    http://msdn.microsoft.com/en-us/library/ms155365(v=sql.110)

    Hope this helps.

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Monday, January 27, 2014 6:27 AM
    Moderator

All replies

  • Hi InsaneDev,

    To use data from an Oracle database in our report, we must have a dataset that is based on a report data source of type Oracle. It means that when we use Oracle database as data source, then we can retrieve report data from an Oracle database. Though the data source is an Oracle database, the report design and render formats are still be depended on Report Builder tool.

    So if we want to change the encoding to UTF-8 when export the report to CSV format, we can solve this issue via modifying the rsreportserver.config as below:

    1. Please navigate to RSReportserver.config file: <drive:>\Program Files\Microsoft SQL Server\MSRS1111.MSSQLSERVER\Reporting Services\ReportServer \RSReportserver.config.
    2. Backup the RSReportserver.config file before we modify it, open the RSReportserver.config file with Notepad format.
    3. Find out the following line:
      <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
    4. Replace it with the following code block:
      <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
       <Configuration>
        <DeviceInfo>
                             <Encoding>UTF-8</Encoding>
        </DeviceInfo>
       </Configuration>
      </Extension>
    5. Save the file and restart the reporting service, and export the CSV file to see whether the issue is solved.


    For more information about CSV Device Information Settings, please see the following document:
    http://msdn.microsoft.com/en-us/library/ms155365(v=sql.110)

    Hope this helps.

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Monday, January 27, 2014 6:27 AM
    Moderator
  • Are you just using Report Builder 3.0 that you've downloaded from Microsoft's website and not SSRS (i.e., publishing your reports to SSRS)?
    Monday, January 27, 2014 2:24 PM