Incorrect Total Pages in SSRS (2014) Report for PDF

Abhishek Bhosekar 1

I am working on Invoice Report(SSRS 2014) which is a huge report consist of multiple sub reports for notes and Terms and conditions. I have used Standard Global Variable to show the page numbers as Globals!PageNumber & " of " & Globals!TotalPages .But, its showing incorrect total pages if the PDF have 9 pages only it will show in the total pages textbox as 10 (1 of 10). In the last page of the PDF shows 9 f 10 pages ,there is no page after the 9th page ,No blank spaces as well. Globals!TotalPages causing the problem. This issue is not coming frequently it is coming for only 2 or 3 invoices among 50. Anyone has any idea to get rid of this issue?

EM 6 Reputation points

2021-09-23T00:33:54.83+00:00

I am having the same issue. Margins are within the page size, no field overflow and when I print it reads 1 of 4, while only 2 pages are prinitng
EM 6 Reputation points

2021-09-23T02:53:21.96+00:00

I resolved my issue. The issue had to do with the Keep-With-Group property.

Use the Advanced Mode to check each of the static members. Mine was the last static and it was Keep-with-Group Before. When I changed it to After, the problem was resolved.

Its as if SSRS tried to keep it together but the rendering inserted some "invisible pages" to accomplish that. I actually saw these "invisible pages" after I deleted the header. I saw all four pages instead of two, which prompted me to look for the Advance Mode properties.

hope that helps.

1 answer

Joyzhao-MSFT 15,566 Reputation points

2021-07-08T02:20:52.51+00:00

Hi @Abhishek Bhosekar ,
Does the behavior of adding extra page numbers only happen when exporting to PDF format?
To ensure that the report size is not the cause of the extra page increase, please make sure: (Body Width + Left margin + Right margin) <= (Page width)

If you have any operations such as grouping or adding page breaks in the report, please let me know.
Best Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Abhishek Bhosekar 1 Reputation point

2021-07-08T08:28:34.963+00:00

Hi @Joyzhao-MSFT Thank you for reply
-Actually, issue is not in Page Number but its in total pages and yes, it is happening only in PDF format.

Yes (Body Width + Left margin + Right margin) <= (Page width) it is less than my page size

My Page Width is 8.5 and body width ,left and right margins is 8.41

8.41 <=8.5

yes, I have a groups and page break in the report.

Joyzhao-MSFT 15,566 Reputation points

2021-07-12T05:52:55.527+00:00

This is really weird. After checking a lot of information, no similar cases were found. I will do further research. If this phenomenon only exists in this report, then the most likely problem is the report itself.

Abhishek Bhosekar 1 Reputation point

2021-07-12T10:42:06.373+00:00

@Joyzhao-MSFT - Yes. This is really weird. Sometimes, report has more data it is working fine But, sometimes its not. .I am also not able to find what actually causing the problem is its a data or something else.

Joyzhao-MSFT 15,566 Reputation points

2021-07-14T06:33:35.313+00:00

The PDF renderer is a physical page renderer and, therefore, has pagination behavior that differs from other renderers such as HTML and Excel.
Have you set visibility in the report? The PDF document is rendered to match the current state of any item in the report. If you hide the content in the report, it will not be visible in the pdf, which may reserve the necessary space. The priority is that your report itself has certain settings.

Abhishek Bhosekar 1 Reputation point

2021-07-15T12:03:01.233+00:00

Yes. There are visibility conditions for almost every row in the report. But, I checked the conditions that any row is showing blank space but it doesn't. Do you have any other solution to resolve this issue. I have done almost all the possible solution to get rid of this problem :(
Sign in to comment