Crosstab sort on field that is not in the crosstab

So I have a crosstab made up of dates for the columns and result names for the rows. I can easily set the dates to be in descending order so the most recent is the first column. I do not want my result names in descending or ascending alphabetical order. I need them in their rowsequence order which is another field. What is the easiest way to set the row sort order in the crosstab to the ascending rowsequence field? I am getting: 12/5/12 11/5/12 Comment: tolerated well did not tolerate well Current Dose: 10mg 20 mg Diagnosis: 122-33 122-33 New Dose: No change 10 mg But I need: 12/5/12 11/5/12 Diagnosis: 122-33 122-33 Current Dose: 10mg 20 mg New Dose: No change 10 mg Comment: tolerated well did not tolerate well Thanks Jil