remove the white space when matrix hidden

Question

 I have a report that has 8 sections. Each section using matrix and needs to show depending on the condition. I would like to remove the white space when it is hidden. I tried setting ConsumeContainerWhitespace to True but it doesn't help. Is it possible to remove the white space? Could you please suggest any alternative solutions if this method doesn't work. These sections are so big so the report doesn't look good. Please suggest.

Thank you.

Answer 1

When you say section, are you using rectangles?  How are you separating each section? where is the white space?

Mark

Answer 2

Hi anate,

According to your description, you want to remove the white space when the section (matrix) is hidden. In Reporting Services, if we hide the section based on an expression, there will no white space when the section is hidden. While once we hide or show the section directly, the space for the section is reserved on the page. Items on subsequent space will start below the reserved space. This is by design.

In order to get rid of the white space, one workaround is place there sections in a separate table rows and then set Hidden of the static row. For more detail steps, please refer to the similar thread:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a34974ea-af84-4fa6-b445-25f9e490def0/how-to-set-rectangle-hight-if-it-hide?forum=sqlreportingservices

If I have something misunderstood, please provide us more information about the report. If possible provide us some screenshots about the report and tell us what the section means. So that we can make further analysis and help you out.

Thanks,
Katherine Xiong

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.