Home » Developer & Programmer » Reports & Discoverer » Report Records display problem (Oracle Report 6i)
Report Records display problem [message #612449] Fri, 18 April 2014 12:30 Go to next message
Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan
Member
I am creating accounts management program in Oracle 6i
In Journal Voucher i have used Two different accounts from Two tables
1. COAL2 Table and 2. Accounts Table
and its two types of Account
1. General Accounts, Its stand alone accounts and used in every records
2. Detail Accounts, Its have sub accounts and used in some records like below screen shot.
http://i58.tinypic.com/2lvlsea.jpg

Now problem is here when i create voucher report its show only detail accounts not show general account
query screen shot and report is attached below.
please check and help me.

http://i57.tinypic.com/2gtvw5h.jpg

http://i61.tinypic.com/n46j9.jpg
Re: Report Records display problem [message #612472 is a reply to message #612449] Sat, 19 April 2014 06:44 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You said:
Quote:

I am creating accounts management program in Oracle 6i

What exactly do you call "Oracle 6i"?

Quote:

problem is here when i create voucher report its show only detail accounts not show general account

I'm not familiar with contents of the second screenshot. What is it?

Here's how I create reports: first, I write a query that is supposed to return desired result set. In your case, that would be a SELECT statement which fetches data from both detail and general account. In order to do that, I'd join these two tables. So, very simplified, this query would look like
select g.col1, g.col2, d.col1, d.col2
from general g, 
     detail d
where d.id = g.id
  and ...

Once I'm sure it is written correctly, I copy/paste it into Reports Builder. In its Data Model layout editor I can develop it further if necessary (by creating groups etc.). Then I let Wizard create the default layout. It is ugly, but it works and puts every field into a correct frame. Finally, I manually rearrange items in Paper Layout editor and that, more or less, does the job.
Previous Topic: Background set in oracle report
Next Topic: How to display a report in Russian on Linux with data in English at back-end???
Goto Forum:
  


Current Time: Thu Mar 28 09:48:34 CDT 2024