[RESOLVED] need help about round off

[morbid.ivan]

i need help about round off.

for example. 123.4567 and the result that im looking for is 123.45.

i need it to be round off in 4rt decimal place

[jggtz]

Where?
Crystal, Access or Data Report?

[morbid.ivan]

Where?
Crystal, Access or Data Report?

Crystal report sir.

[jggtz]

In Crystal Reports ide
Right click over numeric field
A popup menu is displayed with several options
Left click over 'Format Field'
A Format Editor window is displayed
Select Number tab
Left click over 'Customize' button
A Custom Style window is displayed
Select desired 'Decimals'
Select desired 'Rounding'
Click over OK

[morbid.ivan]

In Crystal Reports ide
Right click over numeric field
A popup menu is displayed with several options
Left click over 'Format Field'
A Format Editor window is displayed
Select Number tab
Left click over 'Customize' button
A Custom Style window is displayed
Select desired 'Decimals'
Select desired 'Rounding'
Click over OK

i've try this. but it doesn't work, still rounding off.

[jggtz]

Then You'll need to insert a formula field and write the next code
(change for your real field name)

    TRUNCATE ({NumericFieldName},2)