Crystal version 10, ODBC connection to SQL database
I am trying report all REG and REGADJ transactions BUT these only limited to those that also have RBFER2 and RBFER3 transactions. Having issues in achieving correct results.
Reporting from a transaction table that interchanges the “Amount” field to fit the Tran Code or Allow/Deduc code. Individual transactions are listed per employee and if Tran Code relevant only list once per employee per pay period.
e.g
Emp no Allow/Ded Tran Code Amount
000034 RBFER2 - $ 40.00
000034 RBFER3 - $ 140.00
000034 REG $2500.00
000034 REGADJ $ -190.00
I have tried a configuring via a running total off "amount field" with the following formula:-
if {allow_dedn_code}="RBFER2" or {allow_dedn_code}= "RBFER3"
then {time_code} = "REG"
reset on every employee. No amounts are returned.
Example Report required:-
Emp no Allow/Ded Tran Code Amount RunningTotal
000034 RBFER2 - $ 40.00
000034 RBFER3 - $140.00
000034 - REG $2500.00 $2500.00
000034 - REGADJ $-190.00 $-190.00
000045 SGC $ 700.00
000045 - REG $ 300.00
000099 - REG $1700.00
Appreciate our help
I am trying report all REG and REGADJ transactions BUT these only limited to those that also have RBFER2 and RBFER3 transactions. Having issues in achieving correct results.
Reporting from a transaction table that interchanges the “Amount” field to fit the Tran Code or Allow/Deduc code. Individual transactions are listed per employee and if Tran Code relevant only list once per employee per pay period.
e.g
Emp no Allow/Ded Tran Code Amount
000034 RBFER2 - $ 40.00
000034 RBFER3 - $ 140.00
000034 REG $2500.00
000034 REGADJ $ -190.00
I have tried a configuring via a running total off "amount field" with the following formula:-
if {allow_dedn_code}="RBFER2" or {allow_dedn_code}= "RBFER3"
then {time_code} = "REG"
reset on every employee. No amounts are returned.
Example Report required:-
Emp no Allow/Ded Tran Code Amount RunningTotal
000034 RBFER2 - $ 40.00
000034 RBFER3 - $140.00
000034 - REG $2500.00 $2500.00
000034 - REGADJ $-190.00 $-190.00
000045 SGC $ 700.00
000045 - REG $ 300.00
000099 - REG $1700.00
Appreciate our help