Crystal Reports Newbie help with formula

Report Design

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

Topic: Newbie help with formula

Post Reply

Post New Topic

Author	Message
carwacster Newbie Joined: 14 Dec 2009 Online Status: Offline Posts: 6	Topic: Newbie help with formula Posted: 14 Dec 2009 at 4:58am
	numbervar TGYEAR:=0; TGYEAR:=tonumber({TG_INFO.TG_YEAR})+1; {TG_INFO.TG_YEAR} + "/"+ totext(TGYEAR,0); Is resulting in the years being showing as 2010/2,011 How do i get rid of the "," ?
	IP Logged


lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 14 Dec 2009 at 6:03am
	totext({table.field},0,"")
	IP Logged

carwacster Newbie Joined: 14 Dec 2009 Online Status: Offline Posts: 6	Posted: 14 Dec 2009 at 7:08am
	Thanks lockwelle worked a treat can you explain the issue
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Dec 2009 at 9:20am
	From online help: ToText (x, y, z) x is a Number or Currency value to be converted into a text string; it can be a whole or fractional value. y is a whole number indicating the number of decimal places to carry the value in x to (This argument is optional.). z is a single character text string indicating the character to be used to separate thousands in x. Default is the character specified in your International or Regional settings control panel. (This argument is optional.) "" is an empty string so no seperator is used
	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