Graph missing months

[Simon9999]

Hi

I am using CR XI.

I am trying showing a trend line graph for the last 12 months. Each month plotted shows a total of the previous 12 months (e.g. June 2008 shows a total of July 07 - June 08).

The problem I have is that if a months data is missing, the figure is not shown. E.g. in August 2008 there is no data recorded but there should still be a total which includes Sept 07 - July 08.

Does anyone know how I can get these plotted?

 

[Madawc]

Are you able to get tables / datasets added to the database? If you got a table of MONTH slots set up, this could be linked to the activity using LEFT OUTER and you'd still get a slot when there was no activity. (But note that LEFT OUTER does not work if you also do a selection on the table receiving the LEFT OUTER link.)

I don't think there is any other solution. For totals you can do a Mock-Crosstab, but I doubt there is an option for graphs.

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