Im using SSRS 2005 at the moment. Im trying to do an little more advanced report using a matrix. But i cant figure out how.
3413 35 3513 3613 37 3723
35 36 37 38 39 40
Shoe #1 2 3 2 1 3 1
Shoe #2 1 2 3 5 6 7
The problem is the columns. As you can see there are two rows with column names. And the two rows, Shoe #1 and Shoe #2 are using different rows. Shoe #1 are in sizes 35, 36, 37. And shoe #2 are starting with 34 1/3, 35, 35 2/3.
How can i configure a matrix to display this correctly? Also i would like to have all styles with the 35,36,37 range displayed together, and then the ones that uses 34 1/3, 35... directly after.
Is this possible?