Please i am new to crystal report design. I need your help
I have designed a crystal report from VB.Net that has series of columns (fields) generated from the following two tables.
1. tblAgt - Table
fconsole numeric
fagent
2. tblDebit - Table
fmending Date field
AccountNo
fagent
ftrans
fgrossprem
Comm
The report has the following format
Date: 01/01/2004 To 31/12/2004
Account No: 38000 To 38092
Balance bf: 00.00
fmending AccountNo Fagent ftrans fgrossprem Comm. Net Amt
02/02/04 38837 db001 DR 5,000.00 350.00 4,650.00
02/07/04 38838 db002 CR 15,000.30 200.00 15,200.00
03/02/02 29388 db003 pyt 2,000.00 100.00 1,900.00
The Date and the Accounts Group header were generated with the parameter fields
The balance column is where I am having a problem with because it is suppose to be generated from a summary of all fgrossprem that falls within a range of date below 01/01/2004 (startdate)
ie. fmending < startdate
where startdate and enddate were generated with parameter fields
And the total fgrossprem in table (tbldebitold) is added to fconsole in table (tblagt) ie
Balance bf = fgrossprem + fconsole
I am trying to filter for all the dates that is less than startdate and to get the accumulated fgrossprem but have always got 0.00 as my result.
I would be greatful if you could put me through.
Thanks
fie
I have designed a crystal report from VB.Net that has series of columns (fields) generated from the following two tables.
1. tblAgt - Table
fconsole numeric
fagent
2. tblDebit - Table
fmending Date field
AccountNo
fagent
ftrans
fgrossprem
Comm
The report has the following format
Date: 01/01/2004 To 31/12/2004
Account No: 38000 To 38092
Balance bf: 00.00
fmending AccountNo Fagent ftrans fgrossprem Comm. Net Amt
02/02/04 38837 db001 DR 5,000.00 350.00 4,650.00
02/07/04 38838 db002 CR 15,000.30 200.00 15,200.00
03/02/02 29388 db003 pyt 2,000.00 100.00 1,900.00
The Date and the Accounts Group header were generated with the parameter fields
The balance column is where I am having a problem with because it is suppose to be generated from a summary of all fgrossprem that falls within a range of date below 01/01/2004 (startdate)
ie. fmending < startdate
where startdate and enddate were generated with parameter fields
And the total fgrossprem in table (tbldebitold) is added to fconsole in table (tblagt) ie
Balance bf = fgrossprem + fconsole
I am trying to filter for all the dates that is less than startdate and to get the accumulated fgrossprem but have always got 0.00 as my result.
I would be greatful if you could put me through.
Thanks
fie