No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
hey, Previously I post my question. But it wasn't helped. So I tried own and make sum query. It's not generate 0 value records. can anyone hep me ? select loan.loan_id as 'Loan ID' ,loan.customer_name as 'Customer Name' ,loan.total_amount as 'Total Amount' ,ifnull(sum(settlement.amount),0) as 'Total Received' ,((loan.total_amount)-ifnull(sum(settlement.amount), 0))as 'Total Due' …
|
|
|
Hey guys! I have managed to fix a previous problem but now I have a new one!The "Details" fields keeps repeating itself for example its showing it 4 times instead of one!this is my code [CODE]Dim crptdoc As New CrystalReport1 Dim mystr As String Dim myDS As New DataSet1 crptdoc.Load("C:\Users\ACP\Documents\Visual …
|