Fill in line chart with 0 when data missing

[nicatt]

I have a line chart where I have counts for each month. I am pulling records from an Access database. I am figuring the time service from submit to issue date. I get the months as follows: IF Month (Issued Date}) = 2 Then "Feb" and so forth. I break the chart on @Month which I also group on, incidently. Some months have no records so I can end up with the following months on a chart (January, February, June, August, December) with correct averages. How do I get the missing months on the chart with a zero average? I know the line might go from 10 in February to 0 in March and that is ok.

Thanks in advance for any clues!!

 

[synapsevampire]

Please post technical information when requesting it:

Crystal version
Database/connectivity used
Example data
Expected output

I have a FAQ which addresses this by using a Period Table (standard data warehousing fare):

faq767-4532

-k

 

[nicatt]

I noted in the original post
Database = Access
Example data = IF Month (Issued Date}) = 2
Expected output = Then "Feb" and so forth
Admittedly I did not note that it is Crystal 9.

I have tried the Left outer join to a date table and it throws a DAO error. I will continue to struggle with it.

Thanks anyway