October 2, 2016 at 10:24 pm
I created a drill down report. I have to group columns/fields and set the visibity of some fields.
In text box property i have set the visibity proprty to hide and display can be toggle on the report item .
This workd fine in report but when i tried send this report by exporting to excel , the columns does not show in the excel. How can i make it visible after exporting to excel?
October 3, 2016 at 2:11 am
Think you need to be looking at the hidden property
=IIF(Globals!RenderFormat.Name="EXCELOPENXML",True,False)
or EXCEL in 2008 R2
- Damian
October 3, 2016 at 8:43 am
Is this expression written in textboxproperties -> Visibility-> hide expression?
I have written this expression in above mentioned place , when i do it preview it does not show columns but in excel it does show , is there a way that it shows in both?
October 4, 2016 at 1:52 am
I've just mocked up a quick report (in report builder)
Picked a column and set hidden to =IIF(Globals!RenderFormat.Name="EXCELOPENXML",True,False)
Now exported to Excel and the column is missing as expected
Is there something else you are doing?
- Damian
October 5, 2016 at 9:15 am
the column is missing in "preview" of the report in ssrs .
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply