locked
Replacing Letter in Items on RIGHT RRS feed

  • Question

  • User-992579378 posted

    Dear Legends,

    I have an issue on my report. Any help would be much appreciated.

    Got a field ITEM with the below values

    00B179

    00B180

    21B523S

    23B523S

    And I have used 

    Replace({tab1.ITEM},"S", "U")

    Is there a possible way that I could keep both type of ITEMS ???

    00B179

    00B180

    21B523S

    21B523U

    23B523S

    23B523U

    Many thanks in advance

    Regards,


     

    Wednesday, June 12, 2013 10:25 PM

Answers

  • User1553110397 posted

    Are you using Crystal Report? A solution that I think is- place the field in details section. Also create a formula field using the same field and apply the replacing logic to it. Suppress the formula field if it doesn't match your criteria and place the formula field just below the data field in crystal report.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, June 12, 2013 11:15 PM

All replies

  • User1553110397 posted

    Are you using Crystal Report? A solution that I think is- place the field in details section. Also create a formula field using the same field and apply the replacing logic to it. Suppress the formula field if it doesn't match your criteria and place the formula field just below the data field in crystal report.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, June 12, 2013 11:15 PM
  • User-992579378 posted

    Dear Usha,

    It worked out. Thank you so much for your help :)

    Kind Regards,

    Aamir

    Thursday, June 13, 2013 12:15 AM