Hello Guys,
In my DB I have a column with bool value, when I get a report my report viewer show this column as "TRUE" or "FALSE", I want change this report viewer to show "YES" and "NO". How can I do this?
I posted in attach a image showing this.
Thanks!
In my DB I have a column with bool value, when I get a report my report viewer show this column as "TRUE" or "FALSE", I want change this report viewer to show "YES" and "NO". How can I do this?
I posted in attach a image showing this.
Thanks!
4 Answers, 1 is accepted
0
erwin
Top achievements
Rank 1
Veteran
Iron
Rank 1
Veteran
Iron
answered on 02 Apr 2013, 02:14 PM
You can use the IIf Function in the Value Property of the TextBox.
IIf(Fields.myBoolean,'YES','NO')
Regards
Erwin
IIf(Fields.myBoolean,'YES','NO')
Regards
Erwin
0
Ricardo
Top achievements
Rank 1
Rank 1
answered on 03 Apr 2013, 05:46 PM
Thank you Erwin, IT's working now! :D
0
Dave
Top achievements
Rank 1
Rank 1
answered on 15 Nov 2013, 11:06 AM
Can you do this for a 1 or 0 bit field as well.
0
Squall
Top achievements
Rank 1
Rank 1
answered on 15 Nov 2013, 04:04 PM
Have you tried to use IIF function with bit data fields? If it doesn't work out of the box try with conversion function =IIF(CBool(Fields.MyField),'YES','NO')
SN
SN