Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

nprinting conditional format in pixel perfect not working as expected

I am trying to change the color of the background and font based on the value of the field.  I bring in a text field into nprinting that contains the one of the words:  Green, White, Yellow or Red.  If the value is Green then background should be green and font white, if it is Yellow then background is yellow and font black, etc...

It doesn't look like you can do a nested if as there is only one option for the colors in the formatting rules.  So I created 4 rules and attached them to the object (text field) in the report that contains the value.  But it is nto working as expected.  It formats them to the value of the last rule.  See image.  In the example below.  All of the boxes are red because red is the last rule of the 4.

The formula is the same in all of them.  I am just changing the text for the color and the final format.

What am I doing wrong?

2016-07-05_16-50-24.jpg

2 Replies
Not applicable
Author

my guess is that it is not finding any of them to be true so it defaults to the last one.  So, is the text qualifier correct?  It defaults to the brackets [].  example:  [Green]

jpitamer
Partner - Contributor III
Partner - Contributor III

Hi Deborah,

     The text qualifier must use single quotation marks -> 'Green'. Try this please.

Regards.