Grouping a crosstab

[Jennypi]

Hello,

My query retrieves information like this:
List1, Lot1, Characteristics1
List1, Lot1, Characteristics2
List1, Lot2, Characteristics3
List2, Lot1, Characteristics3
List2, Lot3, Characteristics1

I'm trying to having a report with:
-A group header band to group on List number (List1 first, then List2)
-and then a crosstab Lots/Characteristics, which would show only the lots belonging to a list (a first crosstab with the lots of List1 first, then another crosstab with all the lots from List2).

How can I do that?
I already tried to have:
- a group header band
- a datasource and inside this datasource a crosstab
but the crosstab shows all the records, they are not filtered by what is in the group.

Thank you.

[Jennypi]

an example of my report can be downloaded from here.

[Alex K.]

Hello,

Please try to use the master-detail construction for this task instead grouping. The master data - List1, List2 and the detail - Lot and Characteristics.
Please see the sample report in the atachment.

Thank you.