How to set up a report?

[fkozuch]

Hello everobody,

 

I am facing a problem which I do not know how to figure out in Jasper reports. I started using Jasper a few days ago, so I am beginner so far.

 

Could you help me with following issue?

 

1)Here is SQL query

 

SELECT store.business_name as name_central,store.name as name_shop,SUM(sc_payments_tx.amount) as amount,SUM(sc_payments_tx.fee) as fee,SUM(sc_payments_tx.total_amount) as total_amount,COUNT(sc_payments_tx.fk_id_store) as count

FROM sc_payments_tx

JOIN store ON sc_payments_tx.fk_id_store=Store.id AND sc_payments_tx.sp_id_store=store.partner_id

GROUP BY store.partner_id,store.business_name,store.name

 

2) Result of this query - attachment 1

 

3) Required result is like this - attachment 2 - sum rows included - every name_central and total sum

 

4) Result in Jasper reports - attachment 3 - I am not able to create group of name_central and sum of name_central

 

Thank you very much for any advices!