crosstab 10.1.3.2.1 Sorting at template after data has been retrieved

XML Publisher Desktop 10.1.3.2.1 - I'm trying to sort my data after it has been retrieved by the data definition.  Let's say I have accounts (col), amounts (values), and dates (row).  Sorted by Date at the sql statement level (in the data definition). 

The account I need in the first column, account 100, will show up last if it has no data in the first date (but say account 200 does have data in the first date).  This occurs because I have sorted by date, coupled with the way the crosstab iterates over the dataset.

If I sort by account, then the dates will not start on the first period, but rather the first period that account 100 has data.  In either case, this works perfectly fine if each account has an amount for each date.  That is not always the case though.  Sorting by account and date, or by date and account is the same issue.