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
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
lcohan
Did you tried different format just to see what's going on?
ASKER
Yes, they all work except .csv
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.