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: ShopsItemCategorySalesRankShop_AItemCat_XYZ12341Shop_AItemCat_WST11232............Shop_AItemCat_KML65210Shop_BItemCat_RST512341............Shop_BItemCat_NMK25310Shop_CItemCat_WDT851............ 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_XYZ12341ItemCat_WST11232Shop_A ItemCat_DFG10043ItemCat_RDT9034ItemCat_WSF8525 Shop_A ItemCat_DFG8516Shop_A ItemCat_TZU7997ItemCat_RDT7828ItemCat_PLM6899ItemCat_UHN65210But 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

Hello, I´ve the same problem. How can i solve it? Best regards, Nils

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