SSRS REPORT Invisible columns shown when exported to .csv

3
votes

I have a SSRS report.I had used an expression in the hidden property in the tablix member. My intention is to show only those records which evaluates to 'false' for the expression.

When i export this report to excel, everything is working is fine, i.e hidden records are not shown, but when i export this same report to .csv then hidden records are also shown.

I had tried using =iif(Globals!RenderFormat.Name="CSV", True, False) in the hidden property and also tried changing the "DATA ELEMENT OUTPUT" from auto to output, but they didn't worked.

Does anyone solved this problem earlier ??

2
csvreporting-servicesexport
I believe this is a duplicate of stackoverflow.com/questions/13015873/ssrs-2012-and-csv-export/… If not, please let us know how your problem is different. – Jamie F
Hi Jamie, The problem is same but there isn't any solution provided in the earlier post. – oOo Testing1 oOo
@ShivaShankarReddy If there's another question asking the same thing, please don't post a new duplicate question but instead try to get attention for the old question instead. – Jeroen

2 Answers

1
votes

The "Hidden" property is a formatting property of the report items. When exporting to CSV, all formatting and layout properties are ignored, therefore any data present in the report will be exported to the CSV file, regardless of the value of the "Hidden" property.

One workaround is to use an expression to set the value of the report item such that it is set to nothing or zero instead of being hidden (or as well as being hidden).

1
votes

CSV or XML is data renderer and it only cares about data. It means the data is still included in CSV file even they are hidden in excel exporting. To hide some fields, you should set DataElementOutput = "NoOutPut".