Home » Developer & Programmer » Reports & Discoverer » General Ledger Report
General Ledger Report [message #88860] Mon, 19 May 2003 11:28 Go to next message
Muhammad Ahmad
Messages: 30
Registered: November 2002
Member
i have created a General Ledger report in oracle report builder, by using a sub query i have calculated the opening balance of the ledger and by using formula item i have calculated the running balance, now i want to add this opening balance to the running balance of the first record only but when i add the opening balance to the running balance item it will be added to all the records .... where i need to add the opening balance to the first running balance record only... that's the problem i am facing , can any one help me out !!

thanking you all in anticipation ..
Re: General Ledger Report [message #88861 is a reply to message #88860] Tue, 20 May 2003 01:35 Go to previous messageGo to next message
Muzzammil
Messages: 99
Registered: February 2003
Member
Hi,

Try to build the same report wizard by Group Left option and assign opening balance to apropriate left column.

Its just a hint...Try.
Re: General Ledger Report [message #88919 is a reply to message #88860] Sat, 14 June 2003 03:28 Go to previous message
Muhammad Rizwan
Messages: 1
Registered: June 2003
Junior Member
1) create a summary column which counts the no of rows
name this column as nor.
2) Now create a formula column (balance) which has the following code
if
:nor=1 or :nor=0 then
return sum(:dr)-sum(:cr)+opening_bal;
else
return sum(:dr)-sum(:cr)+:credit;
The source of column where u r calculating the balance
is credit.
Previous Topic: Trouble opening Oracle Browser/Discoverer query
Next Topic: restricting records per page in matrix report at runtime
Goto Forum:
  


Current Time: Thu Mar 28 08:16:36 CDT 2024