Help with Charts

[goduke]

I am creating some charts for some data in my report. The problem I am having is that I am trying to do a simple chart, that shows some counts of a particular field, and its evaluated on change of week. The problem I am running into is that if there isnt any data for that week, then it removes that week totally from the chart. I understand that if there isnt any data, then its not going to be evaluated in the chart. What I would like to do is see if there is any way that you can have the chart show a value of 0 where ever there isnt any data, and the week would still show?

For example...the report shows tickets that came in in the LastFullMonth. For each week ending date, there are counts of those tickets. For week ending 12/31 there were 18 tickets, for week ending 1/7 there were 22 tickets, for week ending 1/21 there were 0 tickets, and for week ending 1/28 there were 25 tickets. So when you build the chart, it only shows the 3 weeks that have data, since there wasnt any data that falls into week ending 1/21. Is there any way to have the report show 0, and still display the date? Any help would be great. Thanks.

 

[Madawc]

I answered your other post. Please don't cross-post.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10