Crystal Reports Number to string Formating

Report Design

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

Topic: Number to string Formating

Post Reply

Post New Topic

Author	Message
gaurav kanthed Newbie Joined: 19 May 2009 Location: India Online Status: Offline Posts: 9	Topic: Number to string Formating Posted: 21 May 2009 at 1:23am
	I want to format the 0.75 as 75% and 0.0615 as 6.15% . How can i achieve this?
	IP Logged


rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 21 May 2009 at 3:24am
	Hi can you let us know,what datatype are you using to store the details below.... cheers Rahul
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 21 May 2009 at 6:19am
	worse comes to worse, you can use totext({table.field}*100, "#,##.##%") if it is a number field, if it is string, I would replace {table.field} with val({table.field}). this will not give consistent alignments as the decimals to the right are not consistent...but some people are ok with that. HTH
	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