Solved

SSRS 2008 .csv issue

Posted on 2014-02-27
5
1,287 Views
Last Modified: 2014-03-05
I run my ssrs 2008 report which is 3 pages long.
I click the Export icon and choose .csv (comma delimited).
Save the report.
Open the report.csv.
The attachmate is what I see.
What is going on ?
rmcoreacctfrt.csv
0
Comment
Question by:thayduck
  • 3
  • 2
5 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 39892625
Did you tried different format just to see what's going on?
0
 

Author Comment

by:thayduck
ID: 39892656
Yes, they all work except .csv
0
 

Author Comment

by:thayduck
ID: 39892729
Found this blog by Russell Christopher on the Internet:
http://blogs.msdn.com/b/bimusings/archive/2007/02/07/reporting-services-why-aren-t-all-my-report-columns-exporting-to-csv-and-or-xml.aspx

Excerpt from this blog:

Here is a semi-complete list of the factors that can impact whether or not your columns are exported when saving to CSV:    

·         Static Values – If a column in your report contains hard-coded static data that doesn’t change from row to row (like the value “hello”), a data render won’t bother exporting it.

·         Expressions on Visibility– If you conditionally flip the Hidden property of a textbox or column in your report, data renderers will automatically omit this data from export, even if the expression evaluates to False (False meaning “don’t hide”). This is a by-design behavior.


On this report I am using hidden Properties on columns of this report. I tried another SSRS 2008 report that does not use hidden properties and it saves to .csv just fine.
0
 
LVL 39

Accepted Solution

by:
lcohan earned 250 total points
ID: 39892776
My guess is that you have Hidden columns like describe below and as this is a given for CSV export you have chice to un-hide or choose different format like Excel (with its own limits!!) then save as CSV.

"To prevent these text-boxes from being exported at the top of the csv file output, the DataElementOutput property for each textbox needs to be changed from “Auto” to “NoOutput”."

http://www.resultdata.com/exporting-a-sql-server-reporting-services-report-options-and-issues/
0
 

Author Closing Comment

by:thayduck
ID: 39907270
Thanks.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Report Builder 9 44
Convert SP in a format for debugging 7 30
sql 2012 cluster  SSRS cluster aware 2 26
sql Total query 2 14
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

930 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now