Monday, March 26, 2012

Rename SQL Bit in Reporting services

Hello,

What is the best way to rename a bit "True/False" to "Open/Closed" or "yes/no" in the expression editior.

Thanks

B

What a simple answer...

=iif(Fields!Fieldname.Value = 0 , "No" , "Yes")

I think sql somehow translates the 0 to a false...

No comments:

Post a Comment