SSRS 2008 .csv issue

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
thayduckProgrammer AnalystAsked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
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
 
lcohanDatabase AnalystCommented:
Did you tried different format just to see what's going on?
0
 
thayduckProgrammer AnalystAuthor Commented:
Yes, they all work except .csv
0
 
thayduckProgrammer AnalystAuthor Commented:
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
 
thayduckProgrammer AnalystAuthor Commented:
Thanks.
0
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.