|
| Many tables and relation sql = many group detailband |
 |
Thu, 26 Jul 2007 16:12:28 -040 |
Hi;
Please I have a problem:
---- 1 TABLE (Headerband) ok this!
* (group one) ok this!
-----2 TABLE (many records) <detailband> ok this!
* (group two) ok this!
my problem is this:
-----3 TABLE (many records) <detailband> not possible this!
..... and more... more.........<detailband> not possible this!
ok, solution this, where?.
thanks everyone.
|
| Post Reply
|
| Re: Many tables and relation sql = many group detailband |
 |
Fri, 27 Jul 2007 07:33:55 -070 |
G.Menèndez Giglio wrote:
> Hi;
> Please I have a problem:
> ---- 1 TABLE (Headerband) ok this!
> * (group one) ok this!
> -----2 TABLE (many records) <detailband> ok this!
> * (group two) ok this!
> my problem is this:
> -----3 TABLE (many records) <detailband> not possible this!
> ..... and more... more.........<detailband> not possible this!
>
> ok, solution this, where?.
The dBASE report engine doesn't really deal well with grandchildren in a
parent/child/grandchild relationship. However, if you turn this into a
flat file (create a single table with all the fields from all tables),
and then group the way you want to, you should be able to get what you
need. This is discussed in my book: The dBASE Reports Book (see below).
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/dbase/dBASEReportsBook.htm
http://www.goldenstag.net/GSP
|
| Post Reply
|
|
|
|
|
|
|
|
|
|