SSRS Selectively Hide Elements


So I have a report, actually a set of reports that has a header section that needs to be printed on some pages and not others.  I have all the charts and graphs placed so that everything fits perfectly on letter landscaped.  Problem is that we don’t want to see the header parts on the screen between each section, only when it is in a PDF or printed…

I stumbled across this gem =IIF(Globals!RenderFormat.IsInteractive = True, True, False)

commit that one to memory!  It is awesome.  At first I was trying to selectively set visibility based on data elements or on format type = PDF etc…

I considered using the ‘header’ section, but we have different stuff on the header sections, and well, it just got all too messy.

Advertisements

Published by

wattersbill72

Dad, Husband, Brother, Son , Soccer Player/Fan, SharePoint Person, All Around Geek

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s