SSRS Report Page break when export to PDF
Hi, I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices. I have grouped the report based on Invoice number, so that the invoices are printed sequentially and there will be page break after each invoice number. Within each invoice there is a header, body and footer. My issue is for certain cases the line items in the body of the invoice, only the last line item moves to the next page. Cretaing a large gap in the body of the report. This happens only for some invoices. I am using Land scape type report, having Page size as 11 * 8.5 inches. I wish any one can solve this issue and grateful if they can give the solution for my problem. I can also send the RDL file, sample data as well as the PDF output for review. Thanks, Mahalingam
September 29th, 2010 2:01pm

Using Rectangles to Control Item Growth and Displacement Items within a rectangle become peers of each other and are governed by the rules of how peer items are positioned on the page as they move or grow. For example: Items will push or displace each other within the rectangle. Items will not push or displace items outside the rectangle, because they are not their peers. If necessary, a rectangle will grow to accommodate the items it contains. You can use this logic to your advantage when dealing with objects that expand. For example: If you want to leave a blank space in your report for a table to expand into, group the blank space and the table in the same rectangle. When the table grows, it will push the blank space. If you want to prevent a matrix from pushing items off the right edge of the page, put the matrix within a rectangle with blank space to its right. Now, the matrix is no longer a peer to the other item on the page and will not be able to push it until the matrix can no longer be contained within its rectangle.
Free Windows Admin Tool Kit Click here and download it now
September 29th, 2010 10:10pm

Hi, Thanks for your reply. I am using a table, group on invoice no. The table has header, detail and footer. I am passing multiple invoice numbers as a parameter. Since the tabel is group by invoice no, each invoice is displayed in each page and there is a page break after each invoice. The header is present in the group header, footer is present in the group footer, detail has the line items of the invoice. My issue is for some invoices, only the last line item of the detail is moved to the next page making a large space in the body of the report. This page break happens only for some situations. I have used a rectangle, inside the table detail and I have placed the data elements. Still the issue is observed. Kindly let know any other suggession to resolve this issue. Thanks, Mahaligaam
September 30th, 2010 9:35am

i've got the same problem. but don't really understand. I found that it need two rectangles inside one another. Apply the conditional formatting to the outside rectangle. and the pagebreak inside. but i just think what the hack is going on with ssrs. :) RegardsOne who can read, have a clear advantage!
Free Windows Admin Tool Kit Click here and download it now
September 30th, 2010 10:03am

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

Other recent topics Other recent topics