I would think that there is a fairly simple resolution to this issue, but I am still too new to Crystal Reports to figure it out on my own. I have searched the forums and the internet and found a few things that look close, but not quite what I need, so I am here for help.
I am using Crystal Reports XI and I have a report that shows the total Change Request that were Initiated by Problem Managment. The report pulls back all the information just fine, and I have it grouped to show the submit date for the Change Request by week. The problem that I am experiencing is that it is only showing the weeks where there was a Change Request submitted from a Problem Investigation and leaves out the weeks where there were not. So instead of getting this:
12/27/2010 - 0
01/03/2010 - 0
01/10/2010 - 1
01/17/2010 - 1
01/24/2010 - 0
01/31/2010 - 0
02/07/2010 - 0
02/14/2010 - 0
I get this:
01/10/2010 - 1
01/17/2010 - 1
When I chart this information in my report it does not show the weeks where there are zeros and that does not help much for showing trending. Of course it can be assumed that there were zeros for the missing weeks, but Managment likes to see the goose eggs when they happen. I have set the field custimization to show NULL values as zeros, but I do not know what I need to do to have the weeks where there are zeros to show in the group. Please help. Any assistance will be greatly appreciated.