If you override GetGroupCaption (e.g. to return “2003” for all dates in theyear 2003 for a date) this will cause the sorting to be incorrect when you groupby more than one column. (where the column with the overridden GetGroupCaptionis the primary group).

 this is because the lastline of the function:

CXTPReportRecordItem::CompareGroupCaption

is:

return Compare(pColumn, pItem);

 
This goes in and comparesthe actual data values, ignoring the overridden caption text.

 The fix is to override CompareGroupCaption, and write:

return GetGroupCaption(pColumn).Collate( pItem->GetGroupCaption(pColumn) );

 
This compare thecaptions (from the overridden GetGroupCaption), rather than the actual datavalues.

I would suggestthat the last line of CXTPReportRecordItem::CompareGroupCaption

be changedfrom:

return Compare(pColumn, pItem);

to

return GetGroupCaption(pColumn).Collate( pItem->GetGroupCaption(pColumn)

Hopefully, what I’m suggestingis correct - can someone from Codejock please comment on this.

Thanks

Warren

...or failing that, there should be a HUGE warning comment in the functions telling you that you MUST override CompareGroupCaption if you override GetGroupCaption.