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

x
  • 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.
0
bigd2001grad
Asked:
bigd2001grad
  • 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.
0
 
simon_kirkCommented:
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:

=IIF((Fields!MYFIELD.Value, "MYDATASET")=1, TRUE, FALSE)

HTH
0
 
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?
0
 
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.
0

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