• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 910
  • Last Modified:

Change Delimiter in CSV File in Reporting Services

I have a scheduled report in Reporting Services and would like to change the delimiter from , too "

Can someone please explain to me exactly how to do this.

I tried to follow this page;

but the confi params didn't exist in my rsreportserver.config file
1 Solution
"CSV" is by very definition Comma Seperated
You might have to define your own file type, with your own delimiter. According to that site you referred to, try adding the following text into your config file:
<Extension Name="QSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
     <Name Language="en-US">Quote (Quotation Delimited Text File)</Name>

Open in new window

CurtinPropAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now