| Report problem [message #389264] |
Fri, 27 February 2009 22:25  |
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  |
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 |
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 713 times)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
