I'm new to Crystal report and i have run into some problems.

 

I'm setting up a report that shows all my customers and their purchase for 2008, so far so good, no problems here.

 

I would then like to show in a graph each customers purchase month by month. I have an order date field in my database i use for this. In the chart expert option i choose the data tab and put in the order date field and choose "On change of" and order by each month. In the "Show value" field i put my total price field from my database.

 

My problem is then, that if a customer hasn't purchased anything for a particular month (let's say March), no column is shown.

 

So what i want is for each customer to have all 12 month displayed in the graph even if there is a zero value for a specific month....???

 

Also i have a budget figure for each customer for 2008. I would like to split this number up for each month and also display this in the graph. Is this possible.....???

 

Any input/soultion is more than welcome....

 

Thanks in advance...