0
votes

I'm trying to make a report in SSRS, and I'd like to toggle the visibility of sections of the report if one section of the report is visible or not.

If section1 is visible
then section2, section3, section4 are hidden;
If section2 is visible
then section1, section3, section4 are hidden;
If section3 is visible
then section1, section2, section4 are hidden;
If section4 is visible
then section1, section2, section3 are hidden;

Is there a way of doing this?

Thanks in advance,
Nick

1

1 Answers

0
votes

Wouldn't you want to define which one is visable using a variable or hidden parameter?

I'd set a parameter with four options 1, 2, 3 and 4, then depending on which one is selected set the visability of the other section individually. E.g. if you used an expression in the visability property of section 1 to =iif(Paramater!Section_Visable.Value=1, false, true)