CODEWITHSUNDEEP
reporting-services
user3014966
user3014966

Reputation: 263

Columns visibility using ssrs

Say I have these columns in my report:

foo
bar
fum
baz

Say that I want to conditionally display this columns based on a toggle item and a specific expression. Also, I want SSRS to collapse the columns for the currently-hidden items. So initially I see:

+foo baz

Then, if I click on the + beside foo, I see:

-foo bar fum baz

Can that be done in ssrs? If so, how? Currently when I click + I get 

-bar fum

Upvotes: 0

Views: 3300

Answers (1)

Steph Locke
Steph Locke

Reputation: 6166

You can make the visibility for numerous textboxes (so all the columns you want to hide) toggle based on a single textbox in the Visibility tab for the textboxes and setting the Display can be toggled by this report item option to the foo column header.

You'll need to be careful to get them all right and set them all (bar, fum) by default to hidden. Since you've already tried to set it, I'd recommend starting your table from scratch and trying to do it a column at a time as you may have some legacy values ticked somewhere that are making things difficult for you.

It sounds like you know what you're doing but here's an in-depth on the topic if you'd like a walkthrough: http://technet.microsoft.com/en-us/library/dd220405.aspx

Upvotes: 2

Related Questions