Answered by:
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.
- Edited by anate Thursday, October 24, 2013 8:20 PM
Answers
-
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=sqlreportingservicesIf 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- Marked as answer by Katherine XiongModerator Tuesday, October 29, 2013 3:44 PM
All replies
-
-
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=sqlreportingservicesIf 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- Marked as answer by Katherine XiongModerator Tuesday, October 29, 2013 3:44 PM