Blank, last page in SSRS-Report

Ok, it took some time but here is a new entry. A short one. 

You may face this problem sooner or later, when creating a SSRS-report with SQL Server 2008. It can happen with both plain Reporting Services and SSRS with Dynamics AX 2012.

After creating a report all looks fine, till you reach the end of the report. Although the last page with report-data has plenty of space left, there is a last completely empty - meaning white page – at the end of the report. 

With Reporting Services for SQL Server 2005 you did not face this kind of problem, because white spaces are removed automatically. This is not a bug just a changed behavior. 

But how to solve this problem with SQL Server 2008?
Quite simple: Just select the properties of the report. Look for the ConsumeContainerWhitespace-property. If the value is FALSE change it to TRUE and your problem with a last white page in SSRS-reports should be history. 



Tipp: If you have the problem that there is a page with report-data, followed by a blank one, followed by a page with report data, a blank one and so on, the problem is different but as easy to solve. Just make sure that Body Width of the report + Left margin + Right margin are together smaller than the Page Width.