Search code examples
ssrs-2008

Unwanted page break in SSRS report

I have an RDL report built in Business Intelligence Studio 2008 and I am having an issue with an unwanted page break.

I have a single dataset with a singletable with some summed data. I have added in a List and added two groups.

enter image description here

I have even checked the page break properties of each one.

enter image description here

enter image description here

The report works fine, but my top most group seems to page breaking, leaving extra pages in the beginning.

What I would like to happen is to have the top most group be a page header, and the second group to be a group header for the detail. Am I going about this the wrong way?

Solution

  • Some things you can look at...

    • Check your report Properties - Look at Consume Container WhiteSpace > Set it to True
    • It looks like you are checking the Tablix page break. Did you right click on each of the Row Group > Group Properties > Page Break Options Between Each Instance of a Group?
    • Another issue could be the margins (make sure they are set to inches if that is what you use). Make sure that your Margins + Report body is less than the printing area you are attempting to print on (screen/pdf/paper/etc).
    • Using '&' for string concatenation instead of '+' (don't know why but this sometimes causes page issues).
    • Check can grow settings on your cells
    • Print destinations settings > properties > check "Override Default settings"
    • Check the white space around your report body (attempt to minimize any if you can) Here is some other useful info about Pagination from MS SQL Server