Hi,
I am not very clear how to do it . Could you explain further or any sample?
From the SQL you show, is it the result of query?

Actual Data:
ItemA, SizeID = A, Size = S, Stock = 10
ItemB, SizeID = A, Size = M, Stock = 5
ItemC, SizeID = B, Size = 6, Stock = 2

ItemName             SizeID  Size   SizeOrder  Stock
ItemA                A       S      1          10
ItemA                A       M      2          10
ItemA                A       L      3          10
ItemB                A       S      1          5
ItemB                A       M      2          5
ItemB                A       L      3          5
ItemC                B       6      1          2
ItemC                B       7      2          2
ItemC                B       8      3          2

If it is the look of the result, how to show horinzontal report?

Thank you