Skip to Content
Former Member
Jan 31, 2008 at 10:05 PM

How to remove the decimal points at the end of the value????



we are using crystal reports 9.0. we have some reports which contains group by field. we have one field like address. if we select group by as address "The data is displayed grouped by the Address. But the address is shown in decimal points". for example if we have 55 as address field value, it shows 55.00.

the formula has written like as follows

if lowercase({?GroupBy}) = 'Address' then totext({rsp_GetDevMicro.Address})

now, i want to remove zeros which comes along with address field values.

can anyone help me in this?