Crystal Reports Hard return in formula?

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Hard return in formula?

Post Reply

Post New Topic

Author	Message
clinteastwood Newbie Joined: 22 Apr 2015 Online Status: Offline Posts: 14	Topic: Hard return in formula? Posted: 29 Oct 2015 at 3:13am
	We are trying to place a signature in a formula field, but am not sure how to place a return in the formula...An example of how we want it is below. Thanks, AUTHOR COMPANY NAME ADDRESS
	IP Logged


clinteastwood Newbie Joined: 22 Apr 2015 Online Status: Offline Posts: 14	Posted: 29 Oct 2015 at 4:10am

	IP Logged

clinteastwood Newbie Joined: 22 Apr 2015 Online Status: Offline Posts: 14	Posted: 29 Oct 2015 at 4:11am
	SORRY, one thing i forgot was that after "Thanks" there is image of a signature, then Author..
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 29 Oct 2015 at 5:20am
	To place an carriage return in any formula with a string add a chr(13) (i.e., {Somefield}+chr(13) )
	IP Logged

clinteastwood Newbie Joined: 22 Apr 2015 Online Status: Offline Posts: 14	Posted: 29 Oct 2015 at 5:55am
	I get the below error when i use the char(13). I do use Char(13) in sql, but i have never tried it in crystal. Below is the code and the result. 'Quality Assurance' + CHAR(13) + 'JimsCrabShack' + ' ' + ' ' + 'Registered Trade Name'
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Oct 2015 at 6:45am
	try CHR not CHAR
	IP Logged

clinteastwood Newbie Joined: 22 Apr 2015 Online Status: Offline Posts: 14	Posted: 30 Oct 2015 at 3:34am
	That did the trick! Thank you very much!
	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