Click here to Skip to main content
15,883,883 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I have created crystal report and open it through the Windows Application.
in case of integer row my no. is 20000 and in report it is displayed like 20,000.
I don't want to display my number as it is.i dont wish to display , in between that no.
Plz help.I really needs help in such case
Posted

All you need to do is Formatting Numbers in Crystal Reports[^]
 
Share this answer
 
Comments
Manas Bhardwaj 4-Sep-12 16:15pm    
Good 5+
Prasad_Kulkarni 5-Sep-12 0:01am    
Thank you Manas!
1) Select Draged field (which appears as 20,000)
2) Select right click on that and select Format Embaded Field option.
3) Where u can find different options for numeric
4) Select option as per your required format..!!
 
Share this answer
 
Comments
Prasad_Kulkarni 5-Sep-12 0:01am    
My 5!
The Sql Coder 25-Oct-12 0:11am    
Thanks
right click on the field, choose format object, then select the number tab.
then click on the customize button. then unchecked the thousands Separator : Symbol : ,
check box.

You are done.

if your field is string
Within Crystal, you can do it by creating a formula[Field Explorer-> Formula Field-> right click->new Formula-> give a name] that uses the ToNumber function. It might be a good idea to code for the possibility that the field might include non-numeric data - like so:
C#
If NumericText ({field}) then ToNumber ({field}) else 0

now follow the above steps for the formula field.
 
Share this answer
 
v2
Comments
astika 4-Sep-12 7:37am    
Thanks for help,but I have no Number tab when i click format Object.
[no name] 4-Sep-12 7:40am    
what is the DataType of the Field?
Just move your mouse over the Field, it will show you as Tool tip.
astika 4-Sep-12 7:51am    
Its string!how to change it?plz help!Thanks
[no name] 4-Sep-12 7:54am    
refer the updated solution.
astika 4-Sep-12 8:32am    
Great thanks,For such nice Help.Its very useful to me!Thanks a lot!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900