Solved

SSRS 2008 .csv issue

Posted on 2014-02-27
5
1,293 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
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.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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