Reporting Services Watermark

Posted on 2006-05-01
Last Modified: 2012-08-13
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.
Question by:bigd2001grad

    Author Comment

    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.
    LVL 14

    Accepted Solution

    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)


    Author Comment

    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?

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now