Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Exporting hidden columns to CSV files

Author  Topic  AHorn Starting Member 1 Post Posted - 2005-08-15 : 20:44:06 I am creating a report were I do not want columns to display if all the values in the column are null. I have added code to hide the columns to the hidden property: iif(len(Fields!FieldName.Value)>0,false,true). This successfully hides the columns when viewing and exporting to Excel, however not when exporting to CSV. Is there any way to make it so that the hidden columns do not appear in the CSV file?