subreport spans multiple pages when saved to pdf

Question

hi we run 2016 enterprise. i have a master report calling my subreport multiple times.

i should start with the sub. when i run it stand alone and save to pdf, it spans multiple pages which dont want. the sub's report page size shows 8.5in, 11in in the properties. and 1 inch all sides margins.

the body is basically 3 rectangles. and its properties show 6.5in w, 6.05256in h.

the top rectangle's properties show 6.5inw, 0.48833in h. the middle (which i dont believe) which contains 2 tablix side by side shows 6.47161in w, 2.38542in h. another answerer said the way i size this rectangle would stay constant so i could insure my bottom rectangle will align near the bottom of the page. but there is no way that height is what i sized it to.

there is one row of independent text boxes below that with a little gap before the last triangle. the last triangle shows properties of 6.49049in w, 2.0625in h. which matches my spec because it needs to be torn off later when a page is printed.

so before i get into the weird behavior coming from the master , how can i get this sub on one page in pdf?

each rectangle specifies keep contents on a single page. while i dont have a printer i can pringt to from the browser, i can print the pdf to paper and will see if perhpas the tablix is extending the page somehow. te right side tablix is meant to take overflow from the left one so everything can stay on one page.

Answer 1

to help this along i encased everything in one rectangle. i also decreased the top and bottom margins to .15in in the master and sub. bottom line, word saves this report pretty much (tiny gaps) as i see it in rm, pdf saves it all messed up. i warned my peers not to save to pdf. and not to even save to pdf from word. just use word for now.

so this question boils down to this. it appears rectangles that contain tablix's cant be relied on to retain their original size (they dont even have a real one in properties) as the tablix's expand. my bottom rectangle needs to print as close to the bottom of the page as possible. i cant use a footer due to the master / sub relationship involved and the sub specific things that go into that bottom triangle. i got misled before but it looks to me like what i really need to do is fake rows in my tablix for white space that will push the bottom triangle downward.

is that my only option? is there a link i can use as a guide?

Answer 2

Hi,
Thanks for the description, now we understand the scene better. You have placed the table in a rectangle, in this case the rectangle will truly grow to have all the table in it.
What you want if the content exceed the rectangle boarder ? I think through this, have not find a good resolution for this.

And yes you need to have items such as blank row or rectangle to have the tablix push down to the bottom, since in SSRS there is no setting to place item to the bottom of the page.
Regards,
Joy

Answer 3

thx, do you have a commonly used example of the pushdown, faking, empty cells part?

we aren't worried about exceeding because we control that in the data source which identifies which tablix the data should show in.

the 2 nd tablix is for overflow and sits side by side with the first.

Answer 4

You could refer to the following link, it may be useful.

1. https://glutenfreesql.wordpress.com/2013/02/14/ssrs-align-text-to-bottom-of-page/
2. https://stackoverflow.com/questions/21866318/ssrs-reports-force-table-to-expand-to-bottom-of-page

Answer 5

thx, i dont understand that align text to bottom link.

when the author wrote add a text box did he mean to a table?

his text box doesnt look like its part of a table. and my component is a rectangle that contains text boxes. does anybody have a suggestion? i'm guessing a rectangle cant be part of/inside a textbox?