September 21, 2017 at 10:06 am
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
January 5, 2018 at 1:21 pm
You have to put an expression on the text box. Go to Text Box properties, Visiblity, click on the fx button to the right of Show or hide based on an expression.
To hide them on everything that is not PDF, use this expression:
=Globals!RenderFormat.Name <> "PDF"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply