[Problem with random separated Groups in Top10-List]

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

[Help, cant post, saying Your submission has triggered the spam filter and will not be accepted.]

Hello,

I´ve the same problem. How can i solve it?

 

Best regards,

Nils

[Scheduler problem - Nothing happens when submitting]

Hi Jordan,

i had the same problem. There ist something wrong with the DatePicker.

When you have a Date like:

dd.MM.yyyy HH.mm

replace it with a Date like:

yyyy/MM/dd HH:mm

(write it i.e. in editor and copy/past it into the field - Jasper won´t let you fill in "/" or "-")

For me it works.

I found it here: http://stackoverflow.com/questions/19709622/jasperreports-server-5-5-create-schedule-not-working

Best regards

Nils