Incorrect Paging in SSRS Report

Incorrect Paging in SSRS Report

While Creating a SSRS Report one of my friend Faced problem like he has some records in his report which were coming in two pages of SSRS Report.

But the Total no. of pages in the report was showing 3 and opening 3rd page was completely blank with no records which was of no use so he don't want to have 3 rd page in Report.

Below screenshot with Empty Records last page.

Solution

I checked the Report the Reason was like the size of Report body was greater then Report size so i changed the Report body to 2 inches

and Report size  to 10 inches 

Preview the report 

Now Report was showing only 2 pages which was Required.

now there was no extra page issue in the Report.

Note:Always keep the Size of Report body less then Report to avoid these types of issue.In order to know how to fix Report body and report size read my post on Report size.

http://sqlandssrssolutions.blogspot.in/2013/12/how-to-fixheight-and-width-of-ssrs.html