I have problem to remove Decimal Places. I have formula and Summary field which sums integer numbers, but they appear in this format 9.00. If I use Crystal Report Designer I can fix this by using Format Field->Number but I want to do this programmatically.This worked for me when I had a number that I wanted to display without the decimals:
ToText({qry_LeaseExtensionDataByQtr_2.Exp Qtr},0)|||Thank you!
I know that this work, but I'm wondering why I can set Field Format thru the Report Designer and can't set it programmatically.|||That solution worked perfect for my situation. I had a GenderID that needed to be concatenated with names, address etc.. My results were 1.00LisaSmithWestAve. The 1.00 was unacceptable. I created @.toTextGender that did this: totext(genderID,0). I then used that formula in my formula that concatenates my data. Thanks for the info.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment