| General Ledger Report [message #88860] |
Mon, 19 May 2003 11:28  |
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 #88919 is a reply to message #88860] |
Sat, 14 June 2003 03:28  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
