Charting a Report

[elliot315]

I'm trying to chart a report but separated by year... I have the report and its perfect but when I try to chart it it presents me the chart for all the years, I want a chart per year. I know the problem has to be with the query but how I manage to present the correct data in every chart?

It is for money collection, every month is presented in a chart for a whole year, so there has to be only 12 months in every chart but I'm getting all the months since January 2006 up to now in every page. So in a page where the report presents the money collected on 2007 the chart presents the data for all the years, and that happens in every year. Thanks for your attention.

 

[JohnAngus]

Without seeing your program it is a little difficult to say - however if you base your report on a query and run the query between a date range it will probably do what you want.

 

[elliot315]

Here is a sample page of the report... as you can see the top part presents the data for a year, but the chart below presents the data for all the money collected during all the years... i just want to see the data for that particular year. The report has various pages, first it presents the data month by month, then comes this charted part and at the end the total collected so far from the first day.