- Create or obtain an image file (jpg, png, bmp) containing the watermark you desire.
- In my case I was placing a "COPY" watermark under a check image.
- I used Paint to create this image file.
- Set the Image Properties according to your SSRS page size.
- I set the Units to "Inches" and the Width and Height according to my margins.
- As I set .25" margins on all sides of the 8.5x11" report page my width was 7.5 and height was 10.
- Save the image file.
- Import the image file into your SSRS report.
- In the Report Data pane add the image to the Images folder.
- Right click the background of the SSRS report to get Body Properties.
- Set the Background Image accordingly.
- "Select the image source" to "Embedded".
- "Use this image:" drop down should have your imported image file.
I'm a former Microsoft Dynamics consultant specializing in SQL Server integrations, reports and customizations.
Wednesday, June 4, 2014
Watermarks in SQL 2008 R2 Reporting Services
I used to think it was a lot harder to add watermarks to an SSRS report but in this version it's not hard at all. After all the watermark is just a "background image" and that is fairly easy to add to a report.
Subscribe to:
Post Comments (Atom)
Photo Watermark does exactly what the name suggests – it lets you add watermarks to photos – but the types of watermarks you can add are quite varied.
ReplyDeleteNot only can you add custom text as a watermark (including changing the font, size and color), you can also use your signature (or any other hand-written text) as a watermark by writing on the screen.
You can also apply stickers, a timestamp, a location, a mosaic effect, or ‘graffiti’ (which basically just lets you go wild on your images with a digital paintbrush). Whether you want to protect your photo or just log when and where it was taken, there should be a tool here to suit.
Photo Watermark is free, but it’s quite heavy on adverts. For $0.99/£0.89 per month you can get rid of them, but unless you’re adding watermarks to a ton of images it’s probably not worth it.