report sections page position issue
I am trying to create a report with 4 separate sections that all fit on a single page. I am having troubles keeping the sections in the same place on the page. The basic layout of the body looks like the following diagram. This is a landscape layout with a body size of 10.5” x 6”. ------------------------------------------------- | | | | section 1 | | | | | | | section 3 | -------------------------- | | | | | section 2 | | | | | | | | ------------------------------------------------| | | | | | section 4 | | | | | ------------------------------------------------| Each section contains one or more tables being filled from various database queries. I have tried using rectangles as containers to hold each section and have created each one the max size of the data to be displayed. However, I still end up with things like the 2<sup>nd</sup> container being pushed down depending on the number of rows returned in the 1<sup>st</sup> container even though the 1<sup>st</sup> container is already sized large enough for the rows being returned. I also tried using subreports that are sized and laid out just the like rectangle container idea. This seems to work okay in the development tool but when I export to PDF (might ultimate goal) the PDF generator strips out all the white space. This pushes each section up and cramps them together. I have been trying various things for the past several days and still do not have a complete understanding of how SSRS positions items on the report page. I would appreciate any help on this issue. Thanks, Barry
March 29th, 2011 5:16pm

It looks like you are using Potrait page why dont you try using Landscape?? I am not sure , may be your tables will get extended as the data you a pulling from your databases. If that's the case you can't do much about it...Dasari
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 10:49pm

Hi Dasari, Actually I am using landscape. The sketch just kind of came out looking like it was in portrait. Thanks, Barry
April 1st, 2011 5:41pm

As a follow-up to this post, I finally got something to work by using rectangles as containers for each section. The trick was not to make the rectangles any larger than the space needed for the design area within the rectangle. If there was extra white-space below a tablix definition in a rectangle then SSRS would try and add the white-space at the end of the page and cause a new blank page to be created. Rectangle 1 and 2 each contain a tablix definition which when run will grow to fill the “(open space)” area below but not beyond the top of rectangle4. Rectangle 3 contains a graph definition that is the same size as the rectangle ------------------------------------------------------- | | | | rectangle 1 | | | | | | | rectangle 3 | |------------------------| | | | | | rectangle 2 | | | | | | | | |------------------------| | | | | | (open space) | | | | | ------------------------------------------------------| | | | | | | | rectangle 4 | | | | | | | -------------------------------------------------------
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2011 9:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics