Hello, I'm trying to format a report so when exported to a comma delimited text it looks like:
Biggest problem is with the quotes, when I add my own, either in query or expression, the csv file will put quotes around the quote.
Any Ideas? Thanks
Please take a look at the following post regarding the CSV export qualifier device info:
Ke Xu - MSFT Reporting Services
I have changed the config on the report server to the following:
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"> <Configuration> <DeviceInfo>However it didnt work. I did this to the rsreportserver.config file in: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
<Qualifier>false</Qualifier> <NoHeader>false</NoHeader> </DeviceInfo> </Configuration> </Extension>
there is also a MSSQL.1 and MSSQL.4 folder but they didnt do appear to have the config file
EDIT: I have verified that MSSQL.3 is the active instance.