asked on

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.

bigd2001grad

ASKER

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.

ASKER CERTIFIED SOLUTION

simon_kirk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bigd2001grad

ASKER

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?

bigd2001grad

ASKER

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.