Value replace in report

[Mando]

Hello,

 

I'm using report designer to build my report, the value comes from the database 1 for male and 2 for female, How can I make it appear as Male or Female ?

I tried a replace in RDLC and it works but not working on telerik

this is the formula I used in .rdlc file:

=Replace(Replace(Fields!Gender.Value,"1","Male"),"2","Female")

[Mando]

for searchers I solved this issue

All what I needed to do is to convert the field value to string before replacing as below

=Replace(Replace(CStr(Fields.Gender),"1","Male"),"2","Female")