Creating reports and dashboards | Stimulsoft community forum

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.

an example of my report can be downloaded from here.

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.