How to Print footer on last page in PDF as well as preview

Print footer on last page in PDF as well as preview

Steps:

1. Design your footer in your visual basic

     (While designing use text box in place of line and use Format TAB near SQL TAB)

Example

2. On each text box, in hidden properties Put this condition.

            =iif(Globals!PageNumber=Globals!TotalPages,false,true)

                (if first page = last page then true)

3. Save and exit