Showing posts with label falsequot. Show all posts
Showing posts with label falsequot. Show all posts

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...