Solved

SSRS Reports Rendering into CSV

Posted on 2014-02-05
5
1,167 Views
Last Modified: 2014-02-11
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

currency_id,currency_name
1,USD
2,GBP

I want to report output OF CSV like this

currency id,currency name
1,USD
2,GBP
0
Comment
Question by:SURESH0518
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 250 total points
ID: 39838070
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, ... ?
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 39838871
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.

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39842496
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.

mlmcc
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS Dynamic Date Parameter 25 583
SSRS Columns as Rows in a Table 14 61
SSRS report parameters set after publishing to report manager 1 72
Install SSRS for developer 1 38
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question