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.
Showing posts with label formula. Show all posts
Showing posts with label formula. Show all posts
Wednesday, March 28, 2012
Subscribe to:
Posts (Atom)