I have my Crystal report grouped and within each group I need to create a chart.  That is not my problem.  I have been asked if I can include all the dates in a bar graph even if there is not data for that date within that group.  Each bar graph fluctuates based on the data measured for each date and that group.  Is there a way to make the bar graph show all the dates from my result set for all the groups?  And if there is no data for that date then you can visibly see it at zero rather than the date not showing at all?

I was afraid of that and I was able to build the full table to include all with our without dates.  Although I have another question.  I want to group the bars in the graph by weekday then by each individual date.  Is there a way to show both labels in the X axis?  I can only seem to show the Weekday then each date is identified in the legend.  We would ideally like to have each date in the x axis horizontally below each bar in the chart. 

I am not.  They would like to see a bar for each date that fall in that weekday group.

Yep, scary minds must think alike. (kidding)  I was working on that piece as a last resort.  So that is what I did.  But I also had to sort my result set by weekday then date in my code and selected the order of the "change on" to be in the Original Order and not Ascending.  That way the dates after each weekday stay in the order I need them to be and Crystal won't rearrange the order.  So my formula is written to display it as an example of Wed 6/29/2011.