Skip to Main Content

APEX 21.1 - Which technique do you use to make APEX reports similar this ?

User_GPTK0Aug 6 2021 — edited Aug 6 2021

I know how to do the report below in Python and Delphi, but I need to do it in Apex 21.1
I made several reports in Apex, but I have no idea how to start this one.
-----------
I have a table named Account
fields:
ID
Bank Name
Date
InitialAmount
Sample Data:
TD Ameritrade 2021/06/01 US$ 300
Bank of America 2020/04/20 US$ 100
Wells Fargo 2018/04/20 US$ 150
----------
And a Table named Transactions
fields:
ID
Bank Name
Date
Type (Debit or Credit)
Description
Amount
Sample Data:
Wells Fargo 2021/05/18 US$ 22 Debit
TD Ameritrade 2021/06/23 US$ 40 Debit
Bank of America 2021/04/20 US$ 90 Credit
TD Ameritrade 2021/08/01 US$ 20 Credit
Bank of America 2021/04/15 US$ 50 Debit
TD Ameritrade 2021/08/03 US$ 100 Debit
----
I need a Report similar this: (choose a Bank Name and display a report)
Date BankAccount TransferAmount Balance
TD Ameritrade 2021/06/01 US$ 300 (Inicial Amount)
TD Ameritrade 2021/06/23 (**-US$ 40) US$ 260 (US$ 300-40)
TD Ameritrade 2021/08/01 US$ 20 US$ 280 (US$ 260+20)
TD Ameritrade 2021/08/03 (
-**US$ 100) US$ 180 (US$ 280-100)
Thank you

Sample_Transactions.png (72.87 KB)

Comments
Post Details
Added on Aug 6 2021
1 comment
52 views