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 ?