Forum Discussion

KellyLyons1's avatar
KellyLyons1
Qrew Trainee
11 months ago

Highlight blank field within a report?

I am trying to highlight only a field on reports that are blank.  I do not want to highlight the entire row, I just want to be able to highlight specific fields (ie Medical Provider, Our Cost, and Related Office to name a few).  

I have tried using formulas with these:

IF(ISNull)

IF(not IsNull)

Nz

I am sure I am just missing something easy, any help would be great



------------------------------
Kelly Lyons
------------------------------

2 Replies

Sort By
  • ChristopherWhea's avatar
    ChristopherWhea
    Qrew Cadet
    11 months ago

    Hi Kelly,

    In order to highlight an individual field you'll have to create a Rich Text Formula that will look at your field of interest.  This can be a Report Formula or an actual Field in your table.

    Here's a very basic example:

    var text emptyStyle = "<span style='background-color:yellow;'>";

    If([Medical Provider] = "", $emptyStyle, "<span>")

    &[Medical Provider]

    &"</span>"

    This is assuming [Medical Provider] is a text field.  If numeric (like a Related or Cost field) you can use the isNull() or Nz() functions



    ------------------------------
    Chris Wheatley
    ------------------------------
    • KellyLyons1's avatar
      KellyLyons1
      Qrew Trainee
      11 months ago

      Thanks Chris, I will give it a try!



      ------------------------------
      Kelly Lyons
      ------------------------------