Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Unanswered: Question about modifying a field output

    Good day.

    I am very new to crystal Reports XI. I have built a report and it works the way I would like except I would like to change the way one of the fields displays but I am not able to figure out how.

    I have a field that displays 000000000000012CF0517 however I only want it to display 12CF0517. Any help would be great.

  2. #2
    Join Date
    Oct 2010
    Posts
    46
    It looks like the field in question is a string and to display 000000000000012CF0517 as 12CF0517 on the report, you would need to use the RIGHT string function to extract the series of characters you needed.

    If you need 8 characters as seen in your example, you would then use the RIGHT function to extract 8 characters from the right side of the string to display 12CF0517.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •