incomplete data for group bar chart

[wanderingsmith]

I have a problem similar to this one (

http://tek-tips.com/viewthread.cfm?qid=1586994&page=22#post).

My first group is salesrep,
then 2 of customer ID (to have individual control over showing the chart in question and a subreport),
then Monthname (

"(" + totext(month({CUSTOMER_ORDER.LAST_SHIPPED_DATE}),"00") + ") " + totext(MonthName (month({CUSTOMER_ORDER.LAST_SHIPPED_DATE}), true))

),
then yearName (

totext({@ShippedYear},"#")

)

The chart is in the customer ID footer right after MonthName, with on change of Monthname and yearname and Showing sum of amount shipped.

And just like MikeSawt, whenever a customer has january data only for, say 2010, then all the other months put 2010 first. Even worse, if february only has 2008 data, it completely scrambles the order by having first 2010, then 2008 and only then 2009, defeating the purpose of visual month to month comparison.

I tried the listed solution by replacing the Monthname group with

{customer.id} & " " & totext(date(year({CUSTOMER_ORDER.LAST_SHIPPED_DATE}),month({CUSTOMER_ORDER.LAST_SHIPPED_DATE}),1),"yyyy-MM-dd")

but then it of course had all the months for 1 year together, then the next year to its right. Instead of having the julys for all 3 years side by side in year order.

I'd appreciate any help