This is a migrated thread and some comments may be shown as answers.

Value replace in report

1 Answer 616 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Mando
Top achievements
Rank 1
Mando asked on 19 Aug 2017, 06:52 PM

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")

1 Answer, 1 is accepted

Sort by
0
Mando
Top achievements
Rank 1
answered on 20 Aug 2017, 10:37 AM

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")

Tags
Report Designer (standalone)
Asked by
Mando
Top achievements
Rank 1
Answers by
Mando
Top achievements
Rank 1
Share this question
or