I have a crystal report linking to Sage Line 50 and Sage Manufacturing tables. In Sage the standard cost field is set to 4 decimal places so it appears 1.9765, I have formatted the field in Crystal to show 4 d.p. and round to 0.0001 but when I run the report the standard cost is rounded to 2 decimal places and padded with zeros i.e. 1.9800. I have pulled this field into an excel query and it is shown as 1.9765 as it is in Sage. How can I get the field to be shown with all four decimals in Crystal?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!