Chart "Datatable" Overrides Number Format

[Erin at CDH]

Dear Folks: I'm trying to use the datatable option of a
chart in a report, and my boss requires that ALL numbers
be formatted out to two decimal places. I've formatted
both the series in the chart to "Number" = 2 decimal
places, and the query beneath it to: Format(
[expression],"Fixed",2), but each time the report is run,
the datatable (beneath the chart) fails to display ALL of
the numbers out to their second decimal place. The
numbers in the chart itself are fine, it's just the
numbers in the chart's datatable which are not.

Any ideas?
Erin and CDH

 

[Evi]

Stinky charts! What about using a query with the same data in a subreport of
the chart report so that it looks like a data table.

Evi