Hi All

I am using CRXI and have designed a report that will list all of our fleet starting with the 'Fleet No.' The fleet no field is a string so that the fleet no.s weren't displaying in number order. I converted the field to a number and it then worked fine. Now, of course, the boffins have decided to create new fleet no.s '7110.1' Of course these weren't displaying on my report. I thought if a played with the 'decimal points' that would help. My report now has '101.0' insted of '101 as well as displaying '7110.1' Is there a formula to suppress the decimal point if it is zero?

 

Thanks in advance for your help

 

Hi

Edited by rahulwalawalkar - 15 Jun 2009 at 7:22am

I am guessing that you are grouping on this field. Continue to group on the numeric formual field, supress it and drop the original field in the header, and it should work fine. It will not change the group tree (if you have one) but the numbers should still be clear. You can also format this field as needed to make it appear as a group header field. If you are using it somewhere else or in some other way please give a description and we can try to figure out how to address it.