SSRS 2008 Hidden Columns Should NOT Export to CSV

Question

When I hide columns in SSRS they still appear in the CSV export.

I have to hide columns, not the entire tablix.

This is what I have tried already: The filters in the tablix hide rows not columns. The DataElementOutput per column can not be set using an expression.

This appears to still be a problem in SSRS 2106... – Peter Tirrell May 22 '18 at 16:55 — Peter Tirrell, May 22 '18 at 16:55

score 9 · Answer 1 · answered Mar 06 '13 at 21:00

9

Format options such as expressions on visibility are ignored for CSV rendering methods. CSV rendering methods are essentially data flows, so you can suppress elements that you don't want to include in CSV files by changing the DataElementOutput from Auto, the default value, to NoOutput.

answered Mar 06 '13 at 21:00

Registered User

8,357
8
49
65

this DataElementOutput is the thing we shud be altering to NoOutput. Nice one. – Mrigesh Raj Shrestha Dec 25 '13 at 05:31
1

As I understand using DataElementOutput property we can statically show or hide column(s) for CSV. But how to do this dynamically, based on expression? – Denys Avilov Sep 28 '17 at 09:45

score 0 · Answer 2 · answered Jun 30 '11 at 05:57

0

There is a solution in the version of SRS 2008 R2, you need to perform a hide fields as follows:

=IIF(Globals!RenderFormat.Name="CSV", True, False)

means this part of the "Globals!RenderFormat.Name" is crucial

answered Jun 30 '11 at 05:57

Tihomir Budic

309
4
13

This piece of code is placed in the hidden property of field, and when the report is run, if he chooses format "CSV" output, this piece of code will hide the field. – Tihomir Budic Nov 24 '11 at 11:01

SSRS 2008 Hidden Columns Should NOT Export to CSV

2 Answers2

Linked