Exactly, that would be the resulting cursor, now what you need to do in your report is group by Item, and all your fields are going to be on your group footer instead of the detail band, the expression for each stock field is:

iif(sizeorder=1,stock,0) 

and i'ts a sum, you would have a fixed number of fields like this, arranged on the same line horizontally, with different values for sizeorder. The reason why I use vertical reports, besides simplicity is that in a horizontal report I'm limited to the number of columns that can fit across the page, in my case I have too many possible sizes to do this, just take a look at the catalog at www.dickies.com, especially the pants, to get an idea. You also need a similar trick to print the actual sizes, any way, I've reproduced what I'm trying to explain here, let me know if you want me to e-mail it to you, and to which e-mail address.

>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