>I have a report that shows a number of numeric fields. The underlying fields have the structure: numeric(12,4). However, I only want to display the first two decimals. I tried using SET DECIMAL 2, but it didn't do anything.
>
>How do I do it???
>
>Pablo
Set Format for the field in report to the desired number of decimals, like:
99999999999.99
If you want to round the value to 2 decimals you may also put into report field Expression:
ROUND(myfield, 2)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison