I have a report that cannot be sorted by Event Start Date due to some weird Microsoft anomaly. This means that the resulting chart is not sorted by month and I'd like to resolve that problem.
This is the exported xml
<fetchcollection>
<fetch mapping="logical" aggregate="true">
<entity name="msevtmgt_eventregistration">
<attribute name="fus_eventstartdate" groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" dategrouping="month"/> <attribute name="fus_totalexpectedcourseregistrationincome" aggregate="sum" alias="_CRMAutoGen_aggregate_column_Num_0"/> </entity>
</fetch>
</fetchcollection>
Can anyone give me an <order> solution to resolve my problem please.
Kevin