GD - DB and BI Community

Microsoft Global Deilvery - Database and Business Intelligence Community posts

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

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

  • Comments 1
  • Likes

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
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment