I have a dataset returned from sql server that can be represented for the
purpose of this discussion with 2 columns. From the server all the data is
sorted first by column 1 and then by column 2 so that the resultset looks
like the following:
column1, column2, column3
a,  1/1/2007, 10
a,  2/1/2007, 30
a,  3/1/2007, 15
b,  10/1/2006, 5
b,  11/1/2006, 1
b,  12/1/2006, 100
b,  1/1/2007, 10
b,  2/1/2007, 9
c,  11/1/2006, 22
c,  12/1/2006, 33
c,  1/1/2007, 44

When I put this data into a matrix with the dates making the columns and
column1 values for each row I get the following

    1/1/2007  2/1/2007  3/1/2007  10/1/2006  11/1/2006  12/1/2006
a        10            30          15
b        10              9                              5                1  
      100
c        44                                                               22
         33

what I want is the following:
     10/1/2006  11/1/2006  12/1/2006  1/1/2007  2/1/2007  3/1/2007
a                                                             10            
30          15
b             5                1          100             10              9
c                              22           33             44

With the dates sorted. I know I can do it by changing the stored proc but
that opens up all sorts of issues with other things. Is there any way to get
the data looking like I want using reporting services and not modifying the
stored proc?

thanks