Tuesday 22 October 2013

How To Watermark your Report With Custom Image


SSRS: How To Watermark your Report With Custom Image
Hello and Welcome, Today our topic to discuss under discussion is how to watermark your image with your custom image or with your company logo. I will be guiding you with an example so that it will be easy to learn for new developers as well

We need a custom image to watermark our report, we shall use the following image,
Just an image with our site URL pasted in it.
Let us make use of already developed report Enable HTML Tags in SSRS Reports (Tutorial here:http://www.heysup.net/ssrs-tutorials/enable-html-tags-in-ssrs-reports/260/ )
Now, in your Report Data navigate to Images folder

Right click and add Image
Browse your Server/PC and select the image you want to have as a watermark. In our case its background.png
First change the format of the image you want to find, its JPEG by default. Select the appropriate one from the drop down menu, select the image and click on Open button. You will end up the image name been displayed in Images folder in your report builder
As, image has been imported in to your report data just we need to call it to watermark the report. In order to do that click somewhere on your report body (remember its report body) and then hit F4 in your keyboard. Properties menu will be displayed navigate to Background Image property
In background image just update your image name manually, please not do not write the extension of the image just write image name. In Source tab select embedded meaning your image is ready in your report data just pull from it.
If in case you have image hosted on some other server and you need to pull it then you select Source as External and value as image path. Here is the screenshot for you
If you have image stored in your database then your source will be Database and value will be the path to database. Then Source will be database and value will be expression and in expression select the column which has images. Here is screenshot for you

That’s it when you click on preview you get to see your background image as watermark to your report here in my case
http://www.heysup.net/ssrs-tutorials/ssrs-how-to-watermark-your-report-with-custom-image/271/

No comments: