locked
Creating watermark based on certain condition in SSRS report RRS feed

  • Question

  • Hi All,

    I want to set watermark  on SSRS report based on certain condition on invoice status .Is it possible ?

    thanks

    SS

    Tuesday, August 7, 2012 3:27 PM

Answers

  • Try the suggestions here.

    For dynamically switching the image based on the status of the invoice, you will need to create another dataset which returns the invoice status value. Then write an expression to show the correct image based on the return value.

    • Proposed as answer by MayankAgrawal Tuesday, August 7, 2012 3:57 PM
    • Unproposed as answer by SSQLL Wednesday, August 8, 2012 10:29 AM
    • Marked as answer by SSQLL Wednesday, August 8, 2012 10:31 AM
    • Unmarked as answer by SSQLL Wednesday, August 8, 2012 10:34 AM
    • Marked as answer by SSQLL Wednesday, August 8, 2012 2:00 PM
    Tuesday, August 7, 2012 3:56 PM

All replies

  • Try the suggestions here.

    For dynamically switching the image based on the status of the invoice, you will need to create another dataset which returns the invoice status value. Then write an expression to show the correct image based on the return value.

    • Proposed as answer by MayankAgrawal Tuesday, August 7, 2012 3:57 PM
    • Unproposed as answer by SSQLL Wednesday, August 8, 2012 10:29 AM
    • Marked as answer by SSQLL Wednesday, August 8, 2012 10:31 AM
    • Unmarked as answer by SSQLL Wednesday, August 8, 2012 10:34 AM
    • Marked as answer by SSQLL Wednesday, August 8, 2012 2:00 PM
    Tuesday, August 7, 2012 3:56 PM
  • Hi Mayank,

    I've tried the option which you provided , got some error like

    Warning 2 [rsInvalidExternalImageProperty] The value of the BackgroundImageValue property for the report section ‘ReportSection0’ is “”, which is not a valid BackgroundImageValue.

    I wrote formula like

    =IIF(First(Fields!statuscodename.Value

    "Dataset1")="Awaiting Printing","Draft.png",nothing)  under Body>Properties>value.Any help ? Thanks SS

    Wednesday, August 8, 2012 10:34 AM
  • it is working Mayank thanks

    Wednesday, August 8, 2012 2:00 PM