It isn't just reports. Any Master/Detail, Parent/Child relationship will be fritzzed in RBase if you have more than ONE linking column with the same name.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Sunday, January 24, 2016 4:45 PM To: [email protected] Subject: [RBASE-L] - RE: sub reports Mike, Thank you! Thank you! Thank you! All these years I did not realize having multiple columns matching would create a problem with sub repots. My logical mind kept saying there should be no reason this should not work. I changed the columns so I only had one common column and, "Presto!" success at last. I knew it had to be something simple. I so appreciate this list. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Sunday, January 24, 2016 9:14 AM To: Jim Belisle Subject: [RBASE-L] - RE: sub reports "There are two common columns in the views: Empid and workdate." Is likely the culprit. If the second or lower table is a temp table, make it a Temp View and give workdate a different name so there is only linkage on EmpId. When you create your SELECT for the columns to be used, use the "AS" operator to give workdate a different name like "WorkDate1" or something that suits you. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Sunday, January 24, 2016 8:10 AM To: [email protected] Subject: [RBASE-L] - sub reports It seems like I can never get a sub report to work properly. I have read the how to manual, and the help information on sub reports. I just cannot seem to get the report to print. I will try to explain my setup. The main report prints just fine. The goal of the sub report is to print the detail of all the entries from a temp table. There are two common columns in the views: Empid and workdate. The setting for the sub report is as follows: Child Keep together Parent Width Visible I placed the sub report in the Break footer of the main report based on the Empid. That band is a dynamic height setting. The subreport pulls from the temp view tempprod I put the fields I want printed in the detail section of the subreport tab. I will not be on line much today but Monday I will check. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]]
