Hi, this question might looks stupid as i'm a newbie on this CR.
I was assigned to make a summary report for file processing using Crystal Report and found some problem here :
No Date Tx_Id Orgnal_Tx_Id Ttl_rcds ok_rcds unprocess_rcds failed_rcds
1 1Mar 001 - 10 2 6 2
2 2Mar 011 001 6 1 3 2
3 3Mar 012 001 5 1 2 2
4 4Mar 013 001 4 2 1 1
5 5Mar 014 001 2 1 1 0
6 6Mar 015 001 1 0 1 0
7 7Mar 016 001 1 0 1 0
This is my file processing result and also the CR preview.. after i run the program, each records will be stored in DB, and i'm not worry about the design as i just pull it out from DB.
i will run this generated report everyday and will show the last 6 days records... (i.e. 7Mar is today... then will show 1-7Mar)
after that, i have to show the summary like this :
Total_records = 10
Successful_records = 7 (total from ok_rcds)
expired records = 3 -- 1+0(both from 7Mar) +
2 (failed rcds 1st time)
the problem is:
how to read and get the expired records which is
3.. i need to get
1 from today's records (unprocessed + failed from 7Mar) and
2 (from first row records)
any formula or tricks can help this?
Thanks a lot for the advice
IP Logged
