Report Chart Datasheet

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have expanded the chart datasheet and set the data to
currency. In the design view I see that the data is
currency. BUT when I go to print preview and print I
loose the currency settings. Any Ideas?

Thanks,
Steve
 
Steve,

I had a very smiliar problem ... after an extensive search
for solutions the following worked for me ...

Open Report in design view
Open properties of chart
Click the ... (or build) next to the row source of the
chart
Change the field to the following EXP1: Format
([fieldname], "Currency")

EXP1 can be changed so it represent an appropriate name as
long as it is not the same as the original fieldname
Fieldname should be the name of the field that you want in
currency format

Save and reopen the chart ...
Hope this helps!

Mathew
 
Back
Top