I want to hide the page footer example - page 1 of 2, 2 of 2 in the report , but when I export to PDF I want to show these.
there is a text box with a notes description and the visibilty of this text box is --
=IIF(Parameters!IsDl.Value = 1, IIF(Globals!RenderFormat.Name <> "EXCEL" AND Globals!PageNumber=Globals!OverallTotalPages, False, True),True)
and there is another text box - and the expression is as follows
=cstr(Globals!PageNumber) + " of " + cstr(Globals!TotalPages)
Both these text boxes are present in the footer