OraFAQ Forum: Reports & Discoverer » how to make Opening balance plus page total as carry forward on page

Home » Developer & Programmer » Reports & Discoverer » how to make Opening balance plus page total as carry forward on page (Oracle reports 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	difficult calculation
Next Topic:	Customizing PickSlip Reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 04:00:15 CST 2024