Expand/Collapse all in drill down report

  • I have a list of tables where each table can be expanded/collapsed individually, but I wonder if there is a way to add a link so that when it is clicked, all of the tables are expanded/collapsed. Anyone have any thoughts?

  • Set the Visibility > ToggleItem property of each table to a single textbox control.

  • But what if you wanted to do both? Give the user the ability to individually expand each section. But, if they have a buch of things expanded, be able to select one item and collapse them all. It would be nice if SSRS could do event statements like VB....maybe there is and I just haven't discovered it yet.

    "One learns best how to put out a fire when he himself is the one on fire..." - me.

  • dmounday (6/11/2009)


    It would be nice if SSRS could do event statements like VB....

    Aye, there's the rub. I have thought the same thing on a number of occasions. Sometimes the solution is to wrap the report viewer in a .NET app, which gives you the report presentation engine in an event-driven context; but obviously there are many situations where this doesn't suit the requirement.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply