Does anyone know of a way to make a column only visible when the drill down(tree view) icon is pressed. I have a report with 4 columns....It's rolled up on column 1, I want 1,3,4 -- to show when its rolled up...When i choose to drill down i want column 2 to also appear. Any help on this one would be appreciated.

So is the toggle expression "column 1" ? If so that fails and the report complains that in toggle items must text boxes that share the same scope as the hidden item or are in a scope that has the hidden item, and cannot be contained in the current report item unless the current grouping scope has a parent. Any thoughts? Also let me clarify this is a DRILL DOWN Report -- I got brain sloppy with my title.

Hi eastern40, To this requirement, I think there is no build-in feature to achieve it. As we cannot get the toggle state dynamically. So we cannot write some expression to control column's visibility based on toggle state. However here I still would recommend you to submit a wish to Microsoft Connect at this link at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release. Regards, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.