reporting services - SSRS 2008 R2 Bug? Still? Dynamically hiding column or tablix and exporting to CSV -


i thought easy task, after several hours of research i'm reading there may ssrs bug when exporting hidden fields csv doesn't make possible?

what i'm looking do:

i have report several columns (let's 50). have parameter drop down report_version allows user select "standard" (all 50 columns) or "express" (only 10 columns). i've been able display 2 versions correctly, when export (the express version) csv shows of columns (and or tablixs) , not results like.

i've read , tried:

  1. if create 2 tablix , hide 1 based on parameter value, export csv still shows both visible , hidden tablix.

  2. if use =iif(globals!renderformat.name="csv", true, false) - doesn't work csv output

  3. changing dataelementoutput = nooutput. hides columns or table csv output, can't dynamically changed based on parameter value.

*** done in "custom code" section via vbscript??

many of articles , threads read through dated 2010-2012 there solution now? i'm @ less here.

help appreciated. thank you

i able work in ssrs 2008 , 2012 based on attempt #2. created dummy report data source query of

select 'value1' col1, 'value2' col2 

i added following expression column visibility column2

=iif(globals!renderformat.name="csv", false, true) 

note true , false reversed sample. when report generated, column 2 hidden, when exported csv, column 2 present.

to incorporate parameter visibility expression, this

=switch(     globals!renderformat.name="csv", false,     parameters!report_version.value = "standard", false,      true, true ) 

this set hidden property of column false if rendered csv, or if "report_version" parameter set "standard", else hide column. expression need added column visibility of every column want hide in "express" version of report.

edit

ok, understand issue , can replicate (i backwards on concept). can explicitly set visibly of column hidden , won't show in csv export. however, when attempt control via expression, csv export ignores setting.

data based exports controlled "dataelementoutput" property. setting "nooutput" suppress element csv output. unfortunately, doesn't appear can controlled expression. microsoft not appear have plans change this(https://connect.microsoft.com/sqlserver/feedback/details/431073/ssrs-programatically-controlling-the-dataelementoutput-property)

the microsoft connect request hints @ creating 2 tablixes , filtering out results each 1 based on parameter supplied (i.e. "express" or "standard"), additionally hiding other tablix based on parameter value. tried , worked halfway. although other tablix had no results, still export column headers , 1 blank row.

now i'd curious know solution issue.


Comments