regarding crystal report formula field
I am new to crystal report.I have a number field which having a value of some number.I just want to display that value like (999.00) that way without using number format ojject,because when i doing like that i just getting 999.00 instead of (999.00) .can u please hele me out of this problem?
How do i write in formula feild that i ll get (999.00) instead of 999.00??
Software/Hardware used:
Software/Hardware used:
ASKED:
October 7, 2008 1:46 PM
UPDATED:
March 15, 2012 12:17 PM
Answer Wiki:
In design mode:
Right click the formula field you want to change
On the drop down select "Format Field"
This should give you the formating options you are looking for
Good Luck!
-Flame
******************************
To see all answers submitted to the Answer Wiki: View Answer History.
Mod note: Prodipto started new question for response. Deleted and merging below.
Prodipto: Thanks for ur ansewr but I think i may not be clear to u .I need to display a number like (xxx.x) instead of xxx.x.According to ur point it only shows xxx.x instead of (xxx.x).Is there any number format function ,so that i ll get number on this format(xxx.x)
If you have a Crystal Reports with Qty and Price fields and you need an additional field in your Crystal Reports for Total, that is TOTAL = QTY X PRICE . In these types of situations you can use the Formula Field in Crystal Reports….
For more details on Formula Field in Crystal Report you may check out these links……
http://www.c-sharpcorner.com/1/61/crystal-reports-C-Sharp.aspx
http://www.mindstick.com/Articles/ad1bda11-7a4c-4760-9df3-987f46b99029/?Formula%20Field%20in%20Crystal%20Report
http://www.codeproject.com/Articles/237030/Using-Formula-in-Crystal-Report