In my SSRS report I have a hidden column. When I export this report to CSV file it includes the hidden column as well. Is there a way I can exclue the hidden column while exporting to CSV file
Does the table control include table footer? Try to remove the table footer, then export the report into CSV file. I found out if the footer text extend into the hidden column area, then the hidden column will also be exported into CSV file.
Please feel free to let me know if I’ve misunderstood anything.
Sincerely,
Zong-Qing Li
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as
Answer” if a marked post does not actually answer your question.
ps_roberts
0 Points
1 Post
Exclude Hide column while exporting to CSV
Dec 18, 2009 03:37 PM|LINK
In my SSRS report I have a hidden column. When I export this report to CSV file it includes the hidden column as well. Is there a way I can exclue the hidden column while exporting to CSV file
Export to CSV format SSRS exclude hidden column
becklery
Member
162 Points
80 Posts
Re: Exclude Hide column while exporting to CSV
Dec 21, 2009 03:35 AM|LINK
Hi.
Please refer to the url below:
http://knowledgebase.localentity.com/?p=99
I believe it can help you.
Good luck!
becklery
Zong-Qing Li...
All-Star
26878 Points
2165 Posts
Re: Exclude Hide column while exporting to CSV
Dec 21, 2009 08:00 AM|LINK
Hi,
Does the table control include table footer? Try to remove the table footer, then export the report into CSV file. I found out if the footer text extend into the hidden column area, then the hidden column will also be exported into CSV file.
Please feel free to let me know if I’ve misunderstood anything.
Zong-Qing Li
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as
Answer” if a marked post does not actually answer your question.