Crystal Reports Formating Concaninated Numbers

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

Topic: Formating Concaninated Numbers

Author	Message
bremen Groupie Joined: 28 May 2013 Online Status: Offline Posts: 93	Topic: Formating Concaninated Numbers Posted: 09 Aug 2013 at 7:00am
	I have two number fields that I am concatenating into one formula {Table1.Field1} & " " & "/" &" " & {Table1.Field2) Currently the numbers in my report show as 1.00 / 5.00. How can I remove the two decimal places from a formula? I have tried to use the format field function but the option to set the number type is not there.
	IP Logged

praveeng Senior Member Joined: 11 Jul 2011 Online Status: Offline Posts: 165	Posted: 09 Aug 2013 at 7:57am
	Hi Bremen, Try below logic ToText({Table1.Field1},0,"") & " " & "/" &" " & ToText({Table1.Field2),0,"") --Praveen Guntuka
	Praveen Guntuka, praveen_guntuka@yahoo.com
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.031 seconds.