Conditional Text 2

[Zugdud]

Hi guys, is there a way to print static text based on a condition? Like:

If not(IsNull{OrderHead.Character01})) Then
"Static Text 1"
Else
"Static Text 2"

?

Thanks!

 

[Zugdud]

Also if its possible, how about conditional "boxes" or underlines?

 

[knitwit]

Sure you can. Just create a variable to hold your static text. Then put in your formula
If not(IsNull({OrderHead.Character01})) Then
"Static Text 1"
Else
"Static Text 2"
(Note the left parenthesis after isnull)
Then right click your field and pick format field, click on the border tab
select the x-2 button to the right of the border that you want and then place the formula that you want to test to put in a border
For example
if not(IsNull({OrderHead.Character01}))
then 1

The 1 will cause the border to print if the formula is true

 

[Madawc]

Shouldn't it be

If not IsNull({OrderHead.Character01}) 
Then
   "Static Text 1"
Else
   "Static Text 2"

Madawc Williams
East Anglia, Great Britain