Jan,
You did give me a good advice. I must admit it was not very clever of me, because there were double column names in the slave tables. They were staring at my face but I did not see it. Every test table had another foreign key, which was referring to the same master table. So I have created for every test table a single table view in which I have replaced the common foreign key with an unique column name. And now it is working wonderful! Thank you all for your help. Tony From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: vrijdag 7 oktober 2011 18:08 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: a report with one master table and 4 slavetables Tony, Don't give up. I know it works because I have done it. Unfortunately it is impossible to see what your doing. Try starting your report over with your master table first and 1 subreport. Make sure it totally does what you want. Then add the 2nd so on. You can do it. Jan -----Original Message----- From: "A.G. IJntema" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 7 Oct 2011 18:02:19 +0200 Subject: [RBASE-L] - Re: a report with one master table and 4 slave tables No, I have a master table and have added the four slave tables to the report as extra tables, like you can do in a form. In my form it is working nicely, every TAB shows a different table. I am beginning to think that it is not possible what I like to achieve. So I have to look for a creative solution, like building a view perhaps? Thank you all for helping me. Tony From: [email protected] [mailto:[email protected]] On Behalf Of William Stacy Sent: vrijdag 7 oktober 2011 17:54 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: a report with one master table and 4 slave tables The only other thing I can think of is that the view is damaged. By that I mean I presume the report is based on a view that contains all 5 tables? Sometimes a column here or there gets unchecked for inclusion in the view, or maybe there's some error in the view links. Finally, the report itself might have gotten damaged. I've certainly had that happen where I had to reconstruct the report from scratch. You might try a very simple report, test it, then go more and more complex with each iteration. On Fri, Oct 7, 2011 at 8:23 AM, A.G. IJntema <[email protected]> wrote: Yes, there is only one common column name. I agree never use the same column name in tables. The fact is that the report works fine as long as I use only one slave table, so I cannot find logic behind this problem. BTW My solution for avoiding double column names is to start every table name with an abbreviation of 3 or 4 characters followed by an underscore and then a logical name. The same applies to the column names. They all start with the same abbreviation followed by an underscore and then a logical name. Only foreign keys do have the same name as in the original master table. For instance: Table: CCT_Client Possible Column names are: CCT_ID which is always the PK CCT_Name Name of the client CCT_Zipcode Zipcode And so on. It works fine, you don’t have to worry about using double column names and you’ll see in a glance to which table a column belongs. Using 9.1 64 you also don’t have to worry about the length of a column name. Tony From: [email protected] [mailto: [email protected] <mailto:[email protected]> ] On Behalf Of William Stacy Sent: vrijdag 7 oktober 2011 15:35 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: a report with one master table and 4 slave tables A long shot: are you sure each child table has one AND ONLY ONE column (the foreign key) in common with it's parent table? Once in a while I'll have more than one inadvertently and that always messes things up. On Fri, Oct 7, 2011 at 6:27 AM, A.G. IJntema < [email protected] <mailto:[email protected]> > wrote: 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] <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 de tail 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 -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
