Options

Wont detect option type- Report

nvermanverma Member Posts: 396
I have created a sub-form. This sub-form contains the following columns (amount (decimal) , description (text) , transaction type (option - Receipt, Cheque).

Based on the transaction type, amount will either be positive (cheque) or negative (receipt).

Now I am trying to create a report that will summarize all the information (cacluate the total amount for transaction type cheque or receipt) for a particular job no.
IF "Consumer Disbursement"."Transaction Type" = "Consumer Disbursement"."Transaction Type"::Receipt THEN
  BEGIN
    TotalAmountReceipt := "Consumer Disbursement".Amount + TotalAmountReceipt;
  END
ELSE
IF "Consumer Disbursement"."Transaction Type" = "Consumer Disbursement"."Transaction Type"::Cheque THEN
  BEGIN
    TotalAmountCheque := "Consumer Disbursement".Amount + TotalAmountCheque;
  END;

Remaining := TotalAmountCheque + TotalAmountReceipt;

For some reason, it wont detect the transaction type: cheque. It calculates the total for receipt but it wont find any cheque type transaction.

Any idea why it might be doing this??

Answers

  • Options
    nvermanverma Member Posts: 396
    Nevermind.
    After spending hours trying to figure out why its not working. I just found the problem and its fixed.
Sign In or Register to comment.