H
hughess7
Hi all
I have a report which includes two chart objects. The data is displayed ok
in design view, but when I preview the reports some of the values show are
not rounded and display more than 2 decimal places. How can I fix these to
two decimals only?
The problem is it is the raw data that is stored with more than 2 decimals.
The datasource for the charts are union queries so I am not sure how I can
format the columns? The sql is select * from dealerwarranty union select *
from nationalwarranty.
There are always two records only for each chart, one for current dealer
values and one for the national values (which are always 100 and need to be a
whole number, not two decimals). The national data is displayed as a trend
line at 100.
Perhaps the most simplest answer would be to store the data as 2 decimals
when it is first imported, is this possible to enforce?
Thanks in advance for any help.
Sue
I have a report which includes two chart objects. The data is displayed ok
in design view, but when I preview the reports some of the values show are
not rounded and display more than 2 decimal places. How can I fix these to
two decimals only?
The problem is it is the raw data that is stored with more than 2 decimals.
The datasource for the charts are union queries so I am not sure how I can
format the columns? The sql is select * from dealerwarranty union select *
from nationalwarranty.
There are always two records only for each chart, one for current dealer
values and one for the national values (which are always 100 and need to be a
whole number, not two decimals). The national data is displayed as a trend
line at 100.
Perhaps the most simplest answer would be to store the data as 2 decimals
when it is first imported, is this possible to enforce?
Thanks in advance for any help.
Sue