Formatting a textbox with IFF
Posted: Wed Jul 03, 2013 9:23 pm
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
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