Export to CSV - ÿþ

Question

Export to CSV - ÿþ

eva-292642

Old Hand

Points: 391
More actions
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

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

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

eva-292642 Old Hand Points: 391 More actions · Answer 1

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:

2. Comment out that section with  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.

jed.dalton SSC Rookie Points: 49 More actions · Answer 2

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

The edit should be as follows:

<Encoding>ASCII</Encoding>

</DeviceInfo>

</Configuration>

</Extension>

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