Using Navision 2015 Report Text Box Properties

I want to highlight the field under the FILL tab in Text Box Properties on a Navision 2015 report, if the field is a quantity field, and the value of the field is "0".

I know I can highlight every other row using: =IIF(RowNumber(Nothing) Mod 2,"#efefef","White")

Best Answers

Answers

  • AntidotEAntidotE Member Posts: 61
    Not sure if I understood your question properly, but will try to answer :smile:
    On report layout designer, select only textbox with quantity and update property BackgroundColor to expression
    =IIF(Fields!Quantity.Value=0,"Red",IIF(RowNumber(Nothing) Mod 2,"#efefef","No Color"))
    
    P.S. I prefer using No Color instead of strict White
    It is hard to swim against self bloodstream... (c) Old, experienced kamikadze.
  • aredmond@thompsonpump.comaredmond@thompsonpump.com Member Posts: 16
    Answer ✓
    Perfect, thank you AntidotE;
  • aredmond@thompsonpump.comaredmond@thompsonpump.com Member Posts: 16
    Answer ✓
    Thank you;
Sign In or Register to comment.