Line graphs in reports -
01-07-2007
, 11:33 AM
Hello.
My database has a number of sites in a table. I have a table that associates
a monthly efficiency figure to each site.
I would like to create a report with a page per site containing a line graph
of the trend in monthly efficiency.
I have a text box in the page header that contains the site index.
I have created the query to give me month and efficiency figure that I use
for the data.
I have used the wizard to create the graph and I have edited the chart's
datasheet and master and child fields.
The most annoying thing is that I have done this already for other
efficiency figures and got it to work in the same database (some time ago,
and I remember having difficulty then).
I have looked at all the properties for the chart and configured them the
same as the working chart, but still no go!
I would be very grateful if anyone could shed some light on how I can make
this work.
Many thanks
PeterW |