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


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).

Comments (1)

  1. Anonymous says:

    This is a good tip