I have problem in crystal report

Posted by Nuwan under ASP.NET on 8/22/2012 | Points: 10 | Views : 1214 | Status : [Member] | Replies : 1
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


Responses

Posted by: Kundan64 on: 1/23/2013 [Member] Starter | Points: 25

Up
0
Down
Create a Formula filed in CR for show the Sum of interest.

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response