SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in



Someone asked me a long time ago how to do watermarking in Reporting Services and I meant to write a blog about it. Then I was asked again just yesterday. So, I figured it was worth a quick blog. In this quick blog, I will show you how to use an image that appears in the background of the report. An assumption is made that you already have an image that can be used as a watermark.


I fired up BIDS (Business Intelligence Development Studio for those of you that are new to BI) and added a new report from my template. I added a quick dataset to my report and threw a table with a few values. Did some slight formatting and then added the image that I planned to use as a watermark. Figure 1 below shows an example before I add the watermark.


Figure 1: Before Watermarking

Before Watermarking - brian k mcdonald, sqlbigeek


Now here is where I need to set the watermark. I selected a white area of my report in the report design surface to ensure that I had the report body selected and hit F4 to show the properties. Then, I just set Source to “Embedded” and selected my newly added watermark image as the Value. Finally, I wanted the watermark to repeat, so I selected Repeat under the BackgroundRepeat property. My settings are shown below in Figure 2.

Figure 2: Body Background Image Settings

Body Settings - brian k mcdonald, sqlbigeek


Instantly, I see the results of my actions in the Report Designer as shown in Figure 3.


Figure 3: Watermark

Watermark - brian k mcdonald, sqlbigeek


This has been a pretty simple demonstration of how to add a watermark, but I hope that you enjoyed it none-the-less. And if you don’t already, please be sure to follow me on twitter at @briankmcdonald. Also note that you can subscribe to an RSS feed of my blogs or find me using any of the below methods.




sqlbigeek, brian k mcdonald


Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant

Email: bmcdonald@SQLBIGeek.com

Blogs: SQLBIGeek | SQLServerCentral | BIDN Articles | BIDN Blogs | SQLServerPedia

Twitter: @briankmcdonald

LinkedIn: http://tinyurl.com/BrianKMcDonald






Posted by Jason Brimhall on 30 June 2011

Useful and sometimes fun.  Thanks for the good info.

Posted by colin.hodges on 3 July 2011

I use a watermark image to show which environment I'm on:

1. Create an Images folder beneath Home on each of the non-production servers; being dev and pre-prod for example

2. Onto each server upload a GIF file named RELEASESTATE.GIF into the Images folder.  Each GIF is to contain large dim grey text with the words of ‘DEV’ or ‘PRE-PROD’ as appropriate

3. Set the following report properties

i. BackgroundImage.Source = External

ii.BackgroundImage.Value = ../images/releasestate.gif  

iii. BackgroundImage.BackgroundRepeat = Repeat

Posted by Brian K. McDonald on 7 July 2011

Thanks Jason! :)

Posted by Brian K. McDonald on 7 July 2011

That's a good idea colin. Thanks for sharing.

Leave a Comment

Please register or log in to leave a comment.