Forum Stats

  • 3,851,903 Users
  • 2,264,050 Discussions
  • 7,904,900 Comments

Discussions

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

User_GPTK0
User_GPTK0 Member Posts: 1 Green Ribbon
edited Aug 6, 2021 1:43PM in APEX Discussions

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



Answers