I want to hide some columns in my report conditionally using an expression when report is exported to CSV format. Column and textbox visibility setting works fine in PDF and Excel format but it is completely ignored in CSV format. There is no
way I can conditionally hide a column in CSV. Google search and few articles suggest that this is by design behavior of SSRS and even Microsoft has confirmed that. Please check following links.
According to your post, I can reproduce the same issue in my test environment (SSRS 2012).
Based on the thread your post, the XML and CSV renderers use the DataElementOutput property to control visibility. We can select which item we want to hide in the report, and set the “DataElementOutput” property with value “NoOutput” to work around the issue.
Alternatively, we can add below expression to control the item’s visibility. Please refer to the expression below:
In order to solve the issue more effective, I recommend you that submit a wish to the Microsoft Connect at
https://connect.microsoft.com/SQLServer/Feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.