Click here to Skip to main content
12,299,323 members (53,704 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SSRS
Hello All,


I have the problem when Exportdata in CSV file.

I have hide some column when i export file in pfd,excel its work fine but when i export file in csv all Hidden columns also display in export file.

E.g.

expected output:
col1 col2 col4 col5
1    2      3    5


Output in CSV file export:
col1 col2 col3 col4 col5

I don't want col3 in csv file because its visibility false however its display.


Please suggest me what i do...
Posted 12-Nov-12 0:32am

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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

Check the above link. It will help definitely..
  Permalink  
Comments
Member 12055745 13-Oct-15 11:46am
   
Hi
I have the same problem like the above question. I have followed every step in given link but its still providing me the data in CSV which I have hide the column.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160525.2 | Last Updated 12 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100