Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Rectangle Auto Growing


Rectangle Auto Growing

Author
Message
BoilerJ
BoilerJ
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 660
I have a tablix inside a rectangle (Region 1). Below my report I have another table/rectangle(Region 2). If the number of rows returned from Region 1 goes over a certain amount of rows, it pushes Region 2 to the next page. What I don't understand is there is PLENTY of white space Region 1. Why would it push the bottom to a second page? I have tried several techniques including the forced lines on the right and bottom of the rectangle (http://lukehayler.com/2009/07/managing-reporting-services-layouts-using-the-rectangle-in-ssrs/ -- it's mentioned in the comments), Nesting Rectangles and using textboxes inside the rectangle (http://connect.microsoft.com/SQLServer/feedback/details/383350/add-can-grow-and-can-shrink-properties-to-rectangle-control), setting ConsumeContainerWhitespace = True, and many others that I was shooting in the dark.

Attached is a screen print of the behavior. This should fit on one page but again it's not.

I would greatly appreciate any help as I have struggled with this for days.
Attachments
Report.jpg (87 views, 143.00 KB)
MWise
MWise
SSC-Addicted
SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)

Group: General Forum Members
Points: 427 Visits: 1747
Have you checked your body size, report size and margins? Does this just happen when you export to PDF or do you get two pages in the report viewer?

MWise



BoilerJ
BoilerJ
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 660
Thanks for the reply,

My body and report size are both 8.5X11 and my margins are set to all 0s.

To answer you second question, I get different results depending on what I change. Sometimes it looks fine in report viewer but is messed up in the export. Other times they are both messed up the same. And again they are both wrong but each is differently wrong. Very frustrating :/
edmebart
edmebart
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 3
-Try Adding a row to the top of the tablix and then to move all into that row. That will make all the same content and will not force the page break.

-Check page break in all the objects to make sure they break at the same moment.
BoilerJ
BoilerJ
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 660
Thanks. I will give that a shot and let you know!
BoilerJ
BoilerJ
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 660
This still pushes me to a second page.
krishnanannapaneni1
krishnanannapaneni1
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 73
Hi,
I had faced the same issue and resolved after changing the page setup settings in report properties.
Please find the attachment Image. May be it will help you.
Attachments
Report_Properties.JPG (217 views, 36.00 KB)
BoilerJ
BoilerJ
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 660
WOW! I have still had issues with this even though this post is over a year old and from what I tested your settings WORKED. How did you think you set the page outside the normal paper size? I never would have thought to do that just in general...thinking it would cause more problems.

Thanks for the reply!
volker.heck
volker.heck
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 5
Very cool solution to my problem.
Many thanks!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search