Value replace in report

2 posts, 0 answers
  1. Mando
    Mando avatar
    14 posts
    Member since:
    Apr 2009

    Posted 19 Aug Link to this post

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

  2. Mando
    Mando avatar
    14 posts
    Member since:
    Apr 2009

    Posted 20 Aug Link to this post

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

Back to Top