Hi, i have this results by query: Store - year - dep - cash 000003 - 1 - 01 - 6517.47 000003 - 1 - 02 - 1780.8 000003 - 1 - 03 - 2270.56 000003 - 1 - 04 - 2669.86 000003 - 1 - 05 - 450.7 000003 - 1 - 07 - 3890.28 000043 - 1 - 01 - 3691.3 000043 - 1 - 02 - 1167.7 000043 - 1 - 03 - 968.18 000043 - 1 - 04 - 1179.86 000043 - 1 - 05 - 172.36 000043 - 1 - 07 - 1509.26 In my jrxml i have create this groups: - Store - Dep and I have the total of rep for only store with variable with this attribute: resetGroup: Store incrementGroup: dep I have to add a Boolean parameter to see the summary of all the stores, broken down by department. The question is: how can I calculate the total of the individual dep by grouping the stores? for ex: 01 6517.47 + 3691.3 Or do I have to make two distinct queries to handle the two results? The solution I found is to go to the query 2 parameters (one for the select fields and one for the group by fields), but I wanted to ask if there is a better solution than this one. Thanks!
