Click here to Skip to main content
15,507,147 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am working on the 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, it is showing incorrect total pages if the PDF has 9 pages only it will show in the total pages textbox as 10 (1 of 10). The last page of the PDF shows 9 f 10 pages, there is no page after the 9th page. No blank spaces as well. The Globals!TotalPages experesion 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?

What I have tried:

I tried to adjust margins,checked subreport output weather i am getting any blank pages in the sub report or in the main report.
Gerry Schmitz 18-Jul-21 3:56am    
Try (Globals!TotalPages - 1)
abhi22bhosekar 20-Jul-21 6:05am    
@Gerry Schmitz - It will fix for only those having page number issue but it will fail for the correct page number. It will always minus the last page number from 1.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900