Adhikar Patil

Adhikar Patil

  • NA
  • 481
  • 129k

I want to skip the Cover Page from count the page numbers

May 9 2020 12:15 PM
Hello,
I want to skip the Cover page based on PageName for count the total number of pages in the footer on every page in SSRS Report.
Beacause i have multiple pages which are showing based on expression, so i want to skip every time Cover page. except cover page every page start with from 1 based on show hide. I have Cover Page, SIA Page, Element Page but when i take all those the first page start with SIA page but when i hide Cover Page the first page start with a Element Page. 
I have the following expression
 
 
=IIF(Globals!PageNumber = 1,"", Globals!PageNumber-1 & " OF " & Globals!TotalPages - 1)
 
please provide me the solution