I have problem in crystal report

Hi All,

I have 2 table, first one is CONTRACT it have con_number, con_name next table is FINANCE it have con_number,rental,interest.
Table data like below.

CONTRACT TABLE
con_number con_name
KY1 John
KY2 Sameer

FINANCE TABLE
con_number rental interest
KY1 100.00 110.00
KY1 100.00 120.00
KY2 200.00 210.00
KY2 200.00 220.00


this is a table structure. I want to display this record in crystal report like below
Contract ConName Interest
KY1 John 230.00
KY2 Sameer 430.00

I created crystal report but Interest sum cant get it repeating like below
KY1 John 110.00
KY1 John 120.00

how i solved this. I group it, but I cant get a good solution.

Please help me.

Rathnayake