Tony, Check for problems with common columns. Ideally there should be only one common column to link between all tables. If that is not the problem consider creating a single view using a collection of NESTED INNER and OUTER JOINS.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 >________________________________ >From: A.G. IJntema <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Friday, October 7, 2011 8:27 AM >Subject: [RBASE-L] - Re: a report with one master table and 4 slave tables > > >Jan, > >Thank you, one moment I thought that does the trick, but from one slave table >all rows are being printed and from the second only a few rows. I cannot think >why this happens. > >Tony > >From:[email protected] [mailto:[email protected]] On Behalf Of jan johansen >Sent: donderdag 6 oktober 2011 21:40 >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: a report with one master table and 4 slave tables > >Tony, > >Make sure that your sub-reports are not included in detail lines. > >Jan > > > >-----Original Message----- >>From: "A.G. IJntema" <[email protected]> >>To: [email protected] (RBASE-L Mailing List) >>Date: Thu, 6 Oct 2011 21:29:21 +0200 >>Subject: [RBASE-L] - a report with one master table and 4 slave tables >>I have one master table (client) and 4 slave tables (with all kind of test >>results). >> >>I like to create a report, starting with the master table and then the >>results of these 4 slave tables, which could have 0 to n rows each. >> >>I have found out that the first slave table is no problem, but then I am >>confronted with the fact that only 1 row from the second, third and fourth >>table is being printed. >> >>I have tried all kinds of variations, like putting them all in the detail >>section of the master table, or creating more levels in the report and put >>every slave table in a separate footer section. >> >>But I am not able solve this problem. >> >>Am I doing something wrong or is it impossible what I like to create. >> >>Hope someone can help me. >> >>Tony IJntema >> > >
