Combine lines in columns

[razorvla]

Hi,

I have a database of fashion articles, where each line has an attribut of category, under-category, and color.

Some articles are in the same under-category but not in the same color.

I'd like to gather these lines in a table with one line for the design, and one column for each color.

I can manage to do it with cross tabs because it has to be placed in the summary, where i cannot group my report by category (i'd like one table per under-category)

Then i thought to use "under-report" to solve this problem, but i cannot make it work...

How can i do ?

Thanks

[razorvla]

the subreport was a nice way to solve this problem. 

It is called at each line of the report, showing data in line (setup in the subreport page format)