Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Account Statement Report

gbtyagMay 25 2007 — edited May 25 2007
Hi!
I'm actually working for a bank and i'm trying to make an account statement report for all client like this

Account No:1
Page 1
------------------------------------------Debit -- Credit
Last balance----------------------- 500 --
Transaction1----------------------- 20 --
Transaction2------------------------XXX -- 30
Transaction3----------------------- 50 --
Total Page 1----------------------- 70 -- 30

Page 2
------------------------------------------Debit -- Credit
Transaction4----------------------- 20 --
Transaction5-----------------------XXXXX -- 50
Total Page 2----------------------- 20 -- 50
Total Account1 Transaction-- 90 -- 80
New balance---------------------- 510

Account No:2
Page 1
------------------------------------------Debit -- Credit
Last balance-----------------------XXXXX-- 70
Transaction1----------------------- 20 --
Transaction2-----------------------XXXXX -- 30
Transaction3----------------------- 50 --
Total Page 1----------------------- 70 -- 30

Page 2
------------------------------------------Debit -- Credit
Transaction4----------------------- 50 --
Transaction5-----------------------XXXXX -- 100
Total Page 2----------------------- 50 -- 100
Total Account2 Transaction-- 120 -- 130
New balance----------------------XXXXX -- 80

I want to put for example 3 transaction max per page. So an Account which have 5 transactions will appear on 2 pages. I want to have sum of debit/credit per page on each page and sum debit/credit of all the account transaction only on the last page of the account. I'm trying to do this since 2 week . It's seem impossible on report
Someboby has already make a report like this? If yes, you can send me an sample at this adress(tyag_ci@yahoo.fr). Or give me tips todo this.
PLZ help!It's very very important.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2007
Added on May 25 2007
2 comments
420 views