Help & Support – Conditional Format

Sage 200 Reporting  –  Help:

Help and Support

Conditional Formatting

A LOGIC statement will evaluate as either TRUE or FALSE – the TRUE result will trigger the conditional formatting – a FALSE result will ignore the conditional formatting.

EXAMPLE 1

A simple example of Conditional Formatting is to SHOW or HIDE a variable (typically a Text Box or Logo image).

As the variable is usually visible on the design prior to any conditional formatting is applied the logic test needs to be constructed so when TRUE the condition to Suppress Printing will be triggered,

It is easier to construct a logic test statement to be TRUE to SHOW a variable – thus the logic statement that would be TRUE to SHOW the variable needs to be negated (NOT) to prevent it from showing.

Show More >>

EXAMPLE 2

A more complex example of Conditional Formatting is to SHOW one Text Box while other Text Boxes are HIDDEN. Consider three Text Boxes that display bank details for Euro, US Dollar and GBP currencies. In the final use of the conditional formatting the three Text Boxes will sit above each other so only one is visible while the other two are suppressed.

Show More >>

EXAMPLE 3

Overlaying Text Boxes are OK. for a few variants but what if you want to select from a dozen or more sales persons depending on a given Cost Centre analysis code held on SOP order header?

Rather than overlay all the possible Text Boxes that would be required it is better to employ an expression that returns TEXT when an IF-THEN-ELSE statement is TRUE.

Show More >>