SSRS 2008 Hidden property for TextBox evaluates to true, exports to CSV anyway?

CSV export is handled quite a bit differently than most SSRS exports: Most of the rendering instructions are ignored. It's considered a "Data Export" not a rendered output.

Up vote 0 down vote favorite share g+ share fb share tw.

I have a a column in a report that has it's visibility controlled by an expression. =IIF(UCase(CStr(Fields!Condition. Value)) = "C",True,False) When the condition is true, the column hides, when it is false, the column is visible.

When I export to Excel and PDF, the rendered respects what this expression evaluates to, and shows the column appropriately. CSV on the other hand, exports the column no matter that the condition evaluates to. I have tried placing this expression in the column visibility, textbox visibility and a bunch of other places.

It doesn't matter where I put it, CSV exports it. I know you can supposedly control the CSV output with the RenderFormat. Name = "CSV", but that seems like an all or nothing approach.

I need it to sometimes to export to CSV and other times not. I really just need this expression to work. Is this a defect in SSRS 2008 and just simply not possible?

Reporting-services ssrs-2008 link|improve this question edited Apr 4 at 14:14Jamie F4,9651313 asked Apr 3 at 23:16user961714296 62% accept rate.

CSV export is handled quite a bit differently than most SSRS exports: Most of the rendering instructions are ignored. It's considered a "Data Export" not a rendered output. But the "DataElementOutput" property for the text cells will control whether a cell's contents are placed in the .

Csv (Textbox Property pane -> Data Only section -> DataElementOutput).

I have taken a look at that property. It looks like it is another "All or nothing" situation. Is this correct?

IE, there is no way to conditionally affect the value of this property? – user961714 Apr 4 at 14:31 Yes, correct. This property can't be set dynamically.

I haven't tried, but you could probably change the content of the cell with the RenderFormat. Name to substitute in an empty string, but you'll still get the field. .

Csv export is designed to have a very stable set of fields exported, so that it can easily be used as an input to automated tools like SSIS. – Jamie F Apr 4 at 14:38 Thanks for your help Jamie. – user961714 Apr 4 at 15:53.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.