Skip to main content
Question

Acumatica Report Designer - Conditional Background/Watermark

  • June 21, 2023
  • 4 replies
  • 227 views
D
Freshman I

Each of my report pages is based on a single record. I’ve heard it rumored that there’s a possibility of making a variable at execution time which would record the value I’m looking for ([PMQuote.CuryAmount]) and return 1 or 0 (or True or False, etc.) when [PMQuote.CuryAmount] > 3000, and then I could use that variable (somehow? Not sure) to control whether or not my background image prints on a page.

I’m new to Acumatica, so I don’t know where to start with this. Can anyone please advise me as to how I might go about doing it?

    4 replies

    D
    Freshman I
    • dgroeben
    • Freshman I
    • November 6, 2023

    I have the same question. A condtional watermark (picture or BIG grey text) to mark a report as DRAFT or NOT APPROVED would be a great feature.

    Dietrich
    B
    Freshman I
    • bchildress77
    • Freshman I
    • April 28, 2026

    I was curious if anyone had an update for this?

    N
    Jr Varsity I
    Forum|alt.badge.img
    • nasir
    • Jr Varsity I
    • April 28, 2026

    ​@DonFord Go to Report menu → Calculated Fields , Add a new calculated field, e.g. ShowBackground 3. Set its Expression to: =IIf([PMQuote.CuryAmount]>3000, True, False)

    Make sure the image element is in the Report Header, Page Header, or the Detail band

      KrunalDoshi
      Varsity III
      Forum|alt.badge.img+1
      • KrunalDoshi
      • Varsity III
      • April 28, 2026

      Hi ​@DonFord,

      I would suggest you add a custom Boolean field in one of your Preferences and use the same in your report to print the background based on that condition.

      Krunal D - Acumatica Developer | www.linkedin.com/in/onlyleader | https://krunaldoshi.com/
        Terms & ConditionsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved