If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > Crystal Reports > Question about modifying a field output

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-31-12, 03:15
ATHOMPSON911 ATHOMPSON911 is offline
Registered User
 
Join Date: Jan 2012
Posts: 1
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.
Reply With Quote
  #2 (permalink)  
Old 02-14-12, 13:19
mission mission is offline
Registered User
 
Join Date: Oct 2010
Posts: 44
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.
Reply With Quote
Reply

Tags
crystal report

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On