Click here to Skip to main content
16,007,472 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

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
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!
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