Home » Developer & Programmer » Reports & Discoverer » how to make Opening balance plus page total as carry forward on page (Oracle reports 6i)
how to make Opening balance plus page total as carry forward on page [message #401028] Fri, 01 May 2009 03:09
adeelpaki
Messages: 1
Registered: May 2009
Junior Member
I have two groups with group above style in oracle reports
queries join with acccount no
g_1 Master
g_2 Detail

G_1 have a headers accounts like 101.
G_1 have a headers accounts like 101.10
G_1 have a headers accounts like 101.10.9
G_1 have a headers accounts like 101.10.9.0

G_2 have a column dr_amt
------------g1
open_bal is coming from a query CF_open_bal_dr
-------g2
dr_amt

things are printing like this
that is master query
g_1

101.
101.10
101.10.9
101.10.9.0

Balance brought forward is called in detail group like this
------------------------
|balance b/f 1000 |
------------------------
G_2
return voucher no, voucher date and dr_amt like this


.............................................page 1
------------------------
|balance b/f 1000 |
------------------------

voucher no | voucher date | dr_amt
==================================
v_1 | 01-mar-2009 | 2000
v_2 | 01-mar-2009 | 1500
v_3 | 01-mar-2009 | 1500
--------------------------------

now I need a page total of 5000


.............................................page 2

------------------------
|balance b/f 6000 |
------------------------

voucher no | voucher date | dr_amt
==================================
v_4 | 01-mar-2009 | 1000
v_5 | 01-mar-2009 | 500
v_6 | 01-mar-2009 | 500
--------------------------------
now I need a page total of 2000

.............................................page 3
------------------------
|balance b/f 8000 |
------------------------

voucher no | voucher date | dr_amt
==================================
v_4 | 01-mar-2009 | 1000
v_5 | 01-mar-2009 | 500
v_6 | 01-mar-2009 | 0
--------------------------------
now I need a page total of 1500

I am interested to print the page toal at the end of page and brought forward or Carry forward above g_2 repeating frame.

I appreciate for your efforts and guideline to resolve the issue

thanks
Adeel
adeel_paki86@hotmail.com
Previous Topic: difficult calculation
Next Topic: Customizing PickSlip Reports
Goto Forum:
  


Current Time: Fri Mar 29 02:58:47 CDT 2024