Problem with random separated Groups in Top10-List

[NiOs]

I´ve a problem with Groups which are seperating randomly, so that i have for one Group Expression more then one printed Group.

My Data is from a ranked Top10_per_Group-SQL Query.
The SQL-Query is Group(ed) By "Shops" and "ItemCategory" and has SUM(ed) "Sales" like:

Shops	ItemCategory	Sales	Rank
Shop_A	ItemCat_XYZ	1234	1
Shop_A	ItemCat_WST	1123	2
...	...	...	...
Shop_A	ItemCat_KML	652	10
Shop_B	ItemCat_RST	51234	1
...	...	...	...
Shop_B	ItemCat_NMK	253	10
Shop_C	ItemCat_WDT	85	1
...	...	...	...

 

In JasperDesigner I created a Group with GroupExpression = "Shops" and the output in a Report is i.e. for Shop_A printed like:

---

Shop_A

---

ItemCat_XYZ	1234	1
ItemCat_WST	1123	2

---

Shop_A

---

ItemCat_DFG	1004	3
ItemCat_RDT	903	4
ItemCat_WSF	852	5

---

 Shop_A

---

ItemCat_DFG

851

6

---

Shop_A

---

ItemCat_TZU	799	7
ItemCat_RDT	782	8
ItemCat_PLM	689	9
ItemCat_UHN	652	10

But the result i want is that all Top10-Items of Shop_A are placed in the Group of Shop_A and all Items of Shop_B are placed in the Group of Shop_B and so on.

The Shops-Field is placed in GroupHeader, the Items-Fields in the Detail1-Band.
When I place all the Fields in the Details-Band, i get the same result like in MSSQL-Server.

I tryed it with several Evaluation Times, but the only result is, that the Group is seperated in another way or with all items.

I hope you understand my problem and are able to solve it.

Please help.

Best regards,
Nils

[cschmidt_2]

I have this same issue, were you able to resolve it?