This is a migrated thread and some comments may be shown as answers.

Conditionnal formatting : checking for true or false

1 Answer 790 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Louis
Top achievements
Rank 2
Louis asked on 14 Mar 2017, 02:11 PM

Hello everyone,

I am looking for the exact syntax for checking a boolean, is it :

=IIF(Fields.BOffreAnnulee==true, "ANNULÉE", null)

=IIF(Fields.BOffreAnnulee=true, "ANNULÉE", null)

=IIF(Fields.BOffreAnnulee = 1, "ANNULÉE", null)

=IIF(Fields.BOffreAnnulee="true", "ANNULÉE", null)

=IIF(Fields.BOffreAnnulee, "ANNULÉE", null)

...

Can't seems to find the right formula, (server is a MS SQL, and the field is a bit in the database)

 

Thanks a lot !

 

Louis

 

 

1 Answer, 1 is accepted

Sort by
0
Accepted
Katia
Telerik team
answered on 14 Mar 2017, 03:36 PM
Hello Louis,

The easiest approach would be to use =IIF(Fields.BOffreAnnulee, "ANNULÉE", null).

=IIF(Fields.BOffreAnnulee="true", "ANNULÉE", null),
 =IIF(Fields.BOffreAnnulee=true, "ANNULÉE", null) and =IIF(Fields.BOffreAnnulee = 1, "ANNULÉE", null) can also be used.

"==" operator cannot be used in Telerik Reporting expressions. Valid comparison operators that can be used in expressions are listed here.

If there are any error messages on report's preview share the screenshot of those.


Regards,
Katia
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Louis
Top achievements
Rank 2
Answers by
Katia
Telerik team
Share this question
or