subreport spans multiple pages when saved to pdf

db042190 1,516 Reputation points
2020-08-20T10:27:53.057+00:00

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.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,940 questions
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. db042190 1,516 Reputation points
    2020-08-27T16:03:29.74+00:00

    you cannot put a rectangle inside of a textbox. the other link didnt help much either. the original poster has a footer. one of the "answerers" suggests using math to estimate how many lines to "insert" which i think could be a nightmare.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.