how to hide a table in SSRS when a new toggle item is chosen (shown)

Lilach_a used Ask the Experts™
I’m using several textboxes to toggle different tables in the same report.
Currently, I can use the toggle items (the textboxes) one by one to open and see each table when its textbox toggle is open. What I would like to do is to make sure that only one table is visible in a report at a specific time: once toggle item is chosen, and its table is shown, I would like all other tables to be hidden.

I’m currently using SSRS 2008 report builder 3.0
Any thoughts?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I assume that you are talking about the textbox which is in tablix
In your textbox toggle item properties use expression like =IIF(Fields!YEAR.value=textbox1, False, True)
This means for textbox1 the items will be expand for others the item will be colapsed.
or If you want to intract with textbox in tablix or outside tablix, you can try with subreport, create each table region as subreport and set hidden for the subreport and toggle property as textbox1.

select the tablix and in hidden property, set it to true with hidden toggle by, give the text box name.
Thank you all.
I’ve solved it through bookmarks: to each textbox I’ve added bookmark to the relevant tablix’s header instead of a toggle item. So now the report user can move from one tablix to the other very freely.

Thanks again,
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial