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.
  1. 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.
  2. Import the image file into your SSRS report.
    • In the Report Data pane add the image to the Images folder.
  3. 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.
The image should show as your background under your report objects.  Note that you may have to set the BackgroundColor properties of objects overlaying the image in the report to "No Color" if they obscure the image.





at

1 comment:

  1. pslvseo a8March 13, 2019 at 11:29 PM

    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.
    Not 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.

    ReplyDelete