Change a bit field using IIf(expr, truePart, falsePart) ?

[Dave]

How do i use the function to change a bit field from 0 or 1 to yes or no?

IIf(expr, truePart, falsePart)

[Petio Petkov]

Hello Dave,

Your expression should be:

=  IIf( Fields.col1 =1 , "yes","no")

Please find attached example.

Regards,
Petio Petkov
Telerik