Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Append letter to record number "special field" Post Reply Post New Topic
Author Message
shabbaranks
Groupie
Groupie


Joined: 06 Oct 2013
Location: United Kingdom
Online Status: Offline
Posts: 66
Quote shabbaranks Replybullet Topic: Append letter to record number "special field"
     Posted: 28 Oct 2013 at 1:15am
Hi,
 
Can anyone tell me if its possible to append letters to the record number within the special fields. So instead of 1 2 3 it would read RES1, RES2 etc?
 
Or would I need to create a formula which uses the record number?
 
Thanks
 
UPDATE: Cracked it, create a custom field and then insert formula = "RES" & " " & recordnumber


Edited by shabbaranks - 28 Oct 2013 at 2:07am
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 29 Oct 2013 at 12:12am
HI
 
You can't modify any special fields or change their functionality.
 
To achive desired results create a formula like :
 
"RES"&Recordnumber
 
 
Thanks,
Sastry
IP IP Logged
shabbaranks
Groupie
Groupie


Joined: 06 Oct 2013
Location: United Kingdom
Online Status: Offline
Posts: 66
Quote shabbaranks Replybullet Posted: 29 Oct 2013 at 12:21am
Originally posted by Sastry

HI
 
You can't modify any special fields or change their functionality.
 
To achive desired results create a formula like :
 
"RES"&Recordnumber
 
 
Thanks, maybe I should have re-posted rather than editing my initial post. I managed to sort it, mainly by trial and error. But thank you for your suggestion :)
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.