Hi everybody,
Small question please, I have one fields unit price which is formated in 5 decimals in the ERP on which i worked : XXX, XXXXX All the prices thus appear in this way:
12,90000 or 0,01230 or 1123,382000
Thus in crystal, I selectionne fields shaping - > number - > personalized and in decimal I put 100000 and in roundness me puts 0,00001.
Only Here we are, when the price is 12,90000, I would want only posted 12,90, or when it is 1123,382000, posted 23,382.
I think that it would be necessary to go to the editor of formula which there is in quoted by decimal and rounded off but I do not really know what to write inside.
If somebody could help me please, that would be really nice.
i worked on Crystal report 10 and on Oracle database
Only.
thanks
Small question please, I have one fields unit price which is formated in 5 decimals in the ERP on which i worked : XXX, XXXXX All the prices thus appear in this way:
12,90000 or 0,01230 or 1123,382000
Thus in crystal, I selectionne fields shaping - > number - > personalized and in decimal I put 100000 and in roundness me puts 0,00001.
Only Here we are, when the price is 12,90000, I would want only posted 12,90, or when it is 1123,382000, posted 23,382.
I think that it would be necessary to go to the editor of formula which there is in quoted by decimal and rounded off but I do not really know what to write inside.
If somebody could help me please, that would be really nice.
i worked on Crystal report 10 and on Oracle database
Only.
thanks