SSRS Reports Rendering into CSV

I have report with two columns curreny id,current Name and when I render into CSV format it  replaces space with "_". Is there any way can we remove "_".
Example: CSV report file have the following records


I want to report output OF CSV like this

currency id,currency name
Who is Participating?
ValentinoVConnect With a Mentor BI ConsultantCommented:
It's indeed not possible.  This is confirmed by the following: select one of your detail-level textboxes and type your label with spaces in the DataElementName property.  This property can be used to specify custom names for column headers when exporting to CSV.  You'll get the following message:

Property value is not valid.

Specify a valid name. The name cannot contain spaces, and it must begin with a letter followed by letters, numbers, or the underscore character (_).

To be honest, I'm not a big fan of spaces in CSV headers either.  If the underscore is such a big problem, perhaps you can use Pascal-case naming styles, like CurrencyID, CurrencyName, ... ?
mlmccConnect With a Mentor Commented:
Another way to handle this is to write an application to read the CSV after it is created and replace the underscores with blanks.

There may even be WIndows utilities that can replace the underscores.

You really should have accepted valentinov's comment as the answer to your question or at least as an assisted answer.  He answered your question about how to do it in SSRS while my comment provided a way to accomplish what you wanted.

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.

All Courses

From novice to tech pro — start learning today.