Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 White space after page break

Author  Topic 

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-22 : 09:38:36
I have a report with 3 charts inside an rectangle and then a table to the right of this rectangle. I have 5 such rectangles and tables in a single report. I have put page breaks after the rectangles. The rectangle is < 11 inches in height and < 16 inches in width with the table.

The problem is when i deploy the report the after every page a large white space is displayed before the contents of next page is shown

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-22 : 11:01:43
what have you set for padding properties of rectangle? also is there some space in designer between rectangles?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-22 : 11:08:46
No padding for the rectangle and also i dont see any padding for rectangle. I am using SSRS2005. No there is no space between the rectangles.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-22 : 11:47:09
hmm...wat about inside rectangle?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-23 : 00:34:37
there are 3 charts in the rectangle
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-23 : 23:56:47
are they perfectly fitting inside rectangle? if there's some space inside rectangle then it can result in white space while rendering

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-26 : 06:12:33
yes they are perfectly fitting inside the rectangle but i do have given some space in between the 3 charts that are inside the rectangle! do you think that can cause the issue??
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-26 : 06:43:02
yep..even that can cause issue. keep the charts together without leaving any space in b/w

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-26 : 07:53:42
did that...thts not helping either...i am wondering may be i have exceeded the physical page size limit of report, may be that is what is causing the white space after page breaks!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-26 : 11:25:15
even that can be reason if report overshoots page width of page.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-27 : 04:57:06
it turns out its the table to the right of the rectangle that is causing the issue, as soon as i removed the table the blank space was gone. Tried to keep the table inside a separate rectangle but the blank space reappeared ?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-27 : 05:06:37
quote:
Originally posted by nitsmooth

it turns out its the table to the right of the rectangle that is causing the issue, as soon as i removed the table the blank space was gone. Tried to keep the table inside a separate rectangle but the blank space reappeared ?


does the table have some hidden column? whats the border width set? is padding also set?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-27 : 05:24:17
no the table has no hidden column and no padding. The border width is 1 pt
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-27 : 06:54:08
hmm...is it by any chance overlapping at least in edges with any other container?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-27 : 08:37:26
dont know what the issue was but i came up with a workaround, my 3 charts were already in a rectangle(R1); i put the table also in the same rectangle(R1) and then put the charts in a new rectangle(R2) so that R2 is in R1....huuhhh!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-27 : 12:55:02
hmm... didnt get why it didnt work otherwise...anyways glad that you sorted it out

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

nitsmooth
Yak Posting Veteran

68 Posts

Posted - 2011-12-28 : 04:59:31
i guess the table while expanding was causing the white space in the report and when i put it in the same rectangle in which the charts were, it somehow got compartmentalized....anyways thanks much for your valuable feedbacks from time to time !!!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-28 : 07:18:32
ok...makes sense

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -