Page 1 of 1

Formatting a textbox with IFF

Posted: Wed Jul 03, 2013 9:23 pm
by erbeynam
If a Boolean value is true, I want to show something, and if false something else.

This works for a label :

{IIF(IsTrue,"ZZA","ZZ1")}

This was working for a count before :

{CountIf(Data, MasterDS.Status_Code == "ZZA")}

Now combine these and it doesn’t work :

IFF(IsTrue, {CountIf(Data, MasterDS.Status_Code == "ZZA")}, {CountIf(Data, MasterDS.Status_Code == "ZZ1")})
Shows “IFF(IsTrue, 10, 0)

{IFF(IsTrue, {CountIf(Data, MasterDS.Status_Code == "ZZA")}, {CountIf(Data, MasterDS.Status_Code == "ZZ1")})}
The error of compilation
The error of compilation is found in the 'Report' report:
} expected

{IFF(IsTrue, CountIf(Data, MasterDS.Status_Code == "ZZA"), CountIf(Data, MasterDS.Status_Code == "ZZ1"))}
The error of compilation
The error of compilation is found in the 'Report' report:
The name 'IFF' does not exist in the current context

Re: Formatting a textbox with IFF

Posted: Thu Jul 04, 2013 1:34 am
by erbeynam
Got it.
{IIF(IsTrue,(CountIf(Data, MasterDS.Status_Code == "ZZA")),(CountIf(Data, MasterDS.Status_Code == "ZZ1")))}

Re: Formatting a textbox with IFF

Posted: Thu Jul 04, 2013 7:07 am
by Alex K.
Hello,

Let us know if you need any additional help.