[RESOLVED] need help about round off

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

Where?
Crystal, Access or Data Report?

Quote:

---

Originally Posted by jggtz

Where?
Crystal, Access or Data Report?

---

Crystal report sir.

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

Quote:

---

Originally Posted by 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

---

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

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

Code:

---

    TRUNCATE ({NumericFieldName},2)

---