Crystal Reports CR XI Number Formatting problem

Report Design

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

Topic: CR XI Number Formatting problem

Author	Message
gaurav kanthed Newbie Joined: 19 May 2009 Location: India Online Status: Offline Posts: 9	Topic: CR XI Number Formatting problem Posted: 19 May 2009 at 7:33am
	I am using the Crystal Report XI . Hi All, I have one table which contain these values 0.0013 1.705 56838 54573 1.0167 but when i am putting into report then it display in this manner 0.00 1.71 56,838.00 54,573.00 1.02 why it's formating automatically ? if i don't want formatting then what should i do?
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 19 May 2009 at 11:31am
	It applies the standard format you have set in File>Options...>Fields Tab > Number. Right click the field and select the format Field, Numbers Tab, Customize. Change the number of decimals you want there.
	IP Logged

gaurav kanthed Newbie Joined: 19 May 2009 Location: India Online Status: Offline Posts: 9	Posted: 19 May 2009 at 11:41pm
	thanks but i need more detail actaully i want this filed as formula and when i am going to multipication tghen that time it's taking only 0.00 not 0.0013 so in the formula workshop how should i treat?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 20 May 2009 at 7:37am
	Before dealing with formula issues you need to check and see if the data was truncated at import or just displaying with the 2 decimal points. Place the field on the report and change the field to display the 4 decimal points. Is is displaying the correct original data of "0.0013" or is it displaying "0.0000" or something else?
	IP Logged

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