Conditionally Show/Hide SSRS items(textbox etc.) based on Rendering(PDF,EXCEL) or Printing

  • Article

We can conditionally show/hide textboxs in SSRS based on rendering or Printing.

If you have to hide something(textbox,label) while normal rendering of report ,but you want that item(textbox,label) in print or while exporting to PDF,Excel then below is the expression to control it.

=iif(Globals!RenderFormat.IsInteractive=TRUE,TRUE,FALSE).