Skip to main content
Solved

Acumatica Report Designer - Conditional Background/Watermark

  • Jun 21, 2023 7:10 PM UTC
  • 4 replies
  • 292 views
  • Translate All
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?

Best answer by nasir

​@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

View original

    4 replies

    Freshman I
    • dgroeben
    • Freshman I
    • Nov 6, 2023 10:58 AM UTC

    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.

    Translate
    Dietrich
    Freshman I
    • bchildress77
    • Freshman I
    • Apr 28, 2026 4:03 AM UTC

    I was curious if anyone had an update for this?

    Translate
    Jr Varsity I
    Forum|alt.badge.img+1
    • nasir
    • Jr Varsity I
    • Answer
    • Apr 28, 2026 9:32 AM UTC

    ​@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

    Translate
      KrunalDoshi
      Pro I
      Forum|alt.badge.img+9
      • KrunalDoshi
      • Pro I
      • Apr 28, 2026 12:04 PM UTC

      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.

      Translate
      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