Search code examples
reporting-servicesssrs-2012ssrs-tablix

Print layout page break/ whitespace issue ssrs


Having a report with 5 different tables and what i want is to have each of these tables starting at the top of a new page. These tables are currently in a rectangle each which has a hide/show expression. Surrounding these rectangles is a list which is doing the correct grouping for the tables and also doing page breaks after each group(3 groups in total: Association, Organization, and Type. There are 5 different types, one for each table(there's a filter on the tables).

When showing my report in regular preview mode there is no problem but when doing so in print layout preview I get the third table starting on the third page but not at the top and after that I dont know what is happening... all page breaks just stops working. Sometimes whole empty pages are rendered.

This is how the report layout looks like

This is some of the resulting pages (not in order)

Just so you know, I have been trying consumewhiteSpace, Checking the height and width on my report Height = 15,1cm and width 24cm and its just a horisontal A4 page.

The grey color is the list-rectangle. Why is it acting up like that and how do I make it work?


Solution

  • So it looks like the report is fixed. Don't really know what I did but I redid the report(like a houndred times before), really made sure that all the page breaks, filters, report margins and visibility conditions (not only in the tables visibility propery but also on every static row under advanced mode) were right. I made some table changes for example using stepped table instead of nested. And found some wrongs I had made previous considering the tables layout (guess everything has a purpos even hard work and long wait...).

    Thanks for the help though!