Post reply

Export to CSV - ÿþ

  • February 10, 2006 at 3:21 am

    #170581

    Hello , I'll try to export an error message. I mean if the user try to view some kind of information that he is not allowed a message must be displayed

    "you are not authorized to view this data"

    This works find in Reporting Services but if I create a subscription to export the report in CSV file I get this -->

    ÿþ

    How I can avoid this and get the message in CSV format??

     

    Thanks

     

  • February 10, 2006 at 5:05 am

    #620071

    I found this , but doesn't work , why????

     

    To get around this dilemma, you can edit Internet Information Server's (IIS) rsreportserver.config file to export to ASCII .CSV by default:

      1. Open the rsreportserver.config file with a text editor and look for this block:

      <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft. ReportingServices.CsvRendering"/>

      2. Comment out that section with <!-- and --> marks.

      3. Directly below that comment section, add the following: 

      <Extension Name="CSV"Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">    <Configuration>     <DeviceInfo>      <Encoding>/ASCII<//Encoding>     </DeviceInfo>    </Configuration>   </Extension>

    4. Run IISRESTART to reload the configuration file.

  • June 16, 2008 at 3:25 am

    #829091

    Thanks, this worked a treat except there is a typo in your configuration.

    The edit should be as follows:

    <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">

    <Configuration>

    <DeviceInfo>

    <Encoding>ASCII</Encoding>

    </DeviceInfo>

    </Configuration>

    </Extension>

    You have put an extra / ahead of ASCII and before </Encoding>

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

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