Home » Developer & Programmer » Reports & Discoverer » Report problem (reports 6i, oracle 9i, Windows 2003 server)
Report problem [message #389264] Fri, 27 February 2009 22:25 Go to next message
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 messageGo to next message
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
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 111 times)
Previous Topic: Drill Down reports
Next Topic: PDF layout conversion problem
Goto Forum:
  


Current Time: Wed Dec 07 04:58:36 CST 2016

Total time taken to generate the page: 0.10529 seconds