[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2639
  • Last Modified:

Reporting Services Watermark

Is there a way I can add a watermark to my reporting services documents dynamically?

Ideally, I'd like to have reporting services check a bit (bool) value in my database and add the watermark (background image) if true, otherwise don't include it.

Thank you in advance and please ask if you'd like more information.
  • 3
1 Solution
bigd2001gradAuthor Commented:
This might be a more straighforward way to approach the problem...

How can I toggle the visibility of a background image of reporting services report?

Hope that helps.
For a dynamic image,goto the properties of the image and select the visibility tab.  Change the Initial Visibility to Expression and enter something like:


bigd2001gradAuthor Commented:
Will this work with a background image?  I can't seem to find an expression field when setting my background image.

Also, I tried this approach just to see if I could get it to work with an image object and the image stayed visible.  So I removed the if statement and set the expression to =False.  After previewing, the imaged remained visible.

Am I making a mistake somewhere or is it a syntax error to set the expression to false?
bigd2001gradAuthor Commented:
I tried pasting the following as an expression into the value field of the report background image, but was told that image.gif was not a valid background image value.

=IIF(First(Fields!MYFIELD.Value, "MYDATASET")=True,image.gif,"")

If I enter image.gif as the value, the report previews correctly - only when I attempt to place it in an expression does it return an error.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now