|
|
| Re: Report Records display problem [message #612472 is a reply to message #612449] |
Sat, 19 April 2014 06:44  |
 |
Littlefoot
Messages: 21823
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 likeselect 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
