Keep Us Together On The Same Line 1

[trenttc]

I want to group by code# (t-shirt) and then group by sku (size), printing the quantity ordered for all skus within a code# all on the same line. Grouping by sku puts sizes in the proper order since the lowest sku number always corresponds to the smallest size. Is there something I can do without having to add a bunch of views of the same table? It would look like this:

T-Shirt S M L X 2X 3X
Code1 1 4 2
Code2 1 2 1 1 1 1

 

[trenttc]

Additonal Info - There is a zize field so (when printing) I can check for the existence of a quantity ordered for each size. I don't just group by size because it would be in a funky order (L M S X). CR 11.

 

[lbass]

Insert a crosstab that uses code as the row, sku as the column, and sum of qty ordered as your summary field. If you want a specific order to the columns, highlight the column field while in the crosstab expert->group options->specified order and select the order of the columns. Place the crosstab in the report header or report footer section.

-LB

 

[trenttc]

I actually figured it out and then checked back here. What I ended up doing is exactly what you suggested.