reporting services - Unhide the hidden columns that are extracted to excel from SSRS -

reporting services - Unhide the hidden columns that are extracted to excel from SSRS -

i have ssrs study , columns hidden when extract excel.

i able hide in excel setting look column visibility

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

but there way user can unhide column in excel (extracted result set) , see info ?

if items hidden in exported excel file don't exist. create items in excel conditionally visible can (for example) add together 2 textboxes follows:

then in sec textbox (which want hide in excel) set visibility "can toggled", utilize toggle first textbox , set default state (in case it's hide, in case can write look hide excel).

then in excel have:

ps. expanded item after opening (by default collapsed).

ssrs-2008 reporting-services reportingservices-2005