I am building a chart off of a query. In this query I have set the properties for the columns to a FIXED format with a 0 for decimal places. But when I print my report, my datasheet does not show this - it shows all of the decimals. One reponse said I should change the SQL behing the chart - did that. :confused:

help me!

Formatting of the fields in the query only formats the display of those values in the query, it doesn't change the underlying data so that it can appear unformatted again on a report.

Try formatting the fields directly on the report.