Adding a Watermark

• leonie6214

  SSC Eights!

  Points: 989

  More actions

  January 6, 2009 at 3:00 pm

  #217187

  How would I add a watermark in a report (report designer) based on certain condition? For example,

  IF Fields!InvoiceID.Value like "ET" OR "GT", (display the following text:) "For Information Only - DO NOT PAY" (Else), " ".

  Can this be do done by editing the watermark in printer settings?

  Thanks,

  leonie6214

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  January 6, 2009 at 4:38 pm

  #922261

  You might want to repost this to the Reporting Services forum.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 7, 2009 at 12:11 am

  #922334

  Continued here - http://www.sqlservercentral.com/Forums/Topic631160-150-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• cavo789

  Mr or Mrs. 500

  Points: 503

  More actions

  January 21, 2009 at 9:12 am

  #930450

  I don't think that this is possible and this for a simple reason : it isn't possible to superpose objects with SSRS (not in the 2005 version).

  You can have a textbox object and show/hide it (with a simple =IF expression in the visible property) but, unlike a watermark, you can't draw something else onto the textbox.

  Christophe