Report problem [message #389264] |
Fri, 27 February 2009 22:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
khalidmehz
Messages: 37 Registered: May 2008 Location: PAKISTAN
|
Member |
|
|
Hi Experts
I am trying to generate output that i have make a sample output in notepad but i am confuse how to do this in reports. I want to make first record closing balance to second record opening balance.
please help me its urgent
[Updated on: Fri, 27 February 2009 22:28] Report message to a moderator
|
|
|
Re: Report problem [message #389276 is a reply to message #389264] |
Sat, 28 February 2009 00:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Annel
Messages: 4 Registered: February 2009 Location: Pakistan
|
Junior Member |
|
|
By your output it seems a very easy report. however, I dont know
what problem exactly are you facing in making this report.
Write the following query:
select open_balance,current,
open_balance+current "Closing Balance"
from [table_name];
I hope that will work for you.
|
|
|
Report problem [message #389280 is a reply to message #389276] |
Sat, 28 February 2009 00:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
khalidmehz
Messages: 37 Registered: May 2008 Location: PAKISTAN
|
Member |
|
|
sorry you cant got my point.
first record
closing balance = 200
second record
opening balance = 200
see the attached image
-
Attachment: data.PNG
(Size: 8.50KB, Downloaded 803 times)
|
|
|