groups, groups and more groups

[gr4nt4]

I'm trying to create a report as follows

1-Store1 statistics(group by store)
3-----Store 1 device1(group by device)

1-Store2 statistics (group by store)
2-- Store 2 order summary of devices 1 & 2(group by store)
3-----Store 2 device 1 orders(group by device)
3-----Store 2 device 2 orders(group by device)


I can get stats by store (1) fine and the device level fine (3) but cannot get (2)

Is it posible to have two groups using the same expression ie 1 & 2 are both by store.

I've tried a subreport for the order summary (2) but it extends the processing time and report size plus I cannot get it not to print when the store only has 1 device even though I can get a count of devices from a variable and use the "print when expression"

any help sugestions?

[file name=SubDetail.jrxml size=31965]