Bruce Are there any other common columns in the 3 tables. If so they also must match.
Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Tuesday, February 23, 2016 9:25 AM To: [email protected] Subject: [RBASE-L] - RE: Sub Report Question: Linking Column Names Let me back up. Main Report Table0.EntityID Sub Report_1 Table1.EntityID, Table1.PersEntityID Sub Report_2 (Nested inside Sub Report_1) Table2.PersEntityID Sub Report_3 (Nested inside Sub Report_2) Table3.PersEntityID The values in question are missing from Sub Report_3. ?? Bruce Chitiea SafeSectors, Inc. 909.238.9012 mobile ------ Original Message ------ Sent: 2/23/2016 5:35:37 AM Subject: [RBASE-L] - RE: Sub Report Question: Linking Column Names From: [email protected] <mailto:[email protected]> To: [email protected] <mailto:[email protected]> Cc: If there are NO common columns, then you will get all the data from the subreport table. I have often created a one-table view of the subreport table to either (a) create only one common column in case there's >1 common and that prevents a match, or (b) purposely rename the common column in the view so that all rows will match. I have a report that has a bunch of data, and they wanted a chart of the "lookup values" at the bottom to show a list of Code values. Since there was one common column for the lookup, it would have shown only the one matching row. So I created a view, with the common column as an alias, and it shows the full lookup chart nicely at the bottom! Subreports are very cool, and one of the ways to convert those old DOS routines where they would print multiple reports to a file. Karen -----Original Message----- From: Bruce Chitiea < <mailto:[email protected]> [email protected]> To: karentellef < <mailto:[email protected]> [email protected]> Sent: Mon, Feb 22, 2016 4:54 pm Subject: [RBASE-L] - RE: Sub Report Question: Linking Column Names John: Thanks. Just getting into sub reports and seeing really powerful possibilities. Enjoy your posts. Bruce Chitiea SafeSectors, Inc. 909.238.9012 mobile ------ Original Message ------ Sent: 2/22/2016 2:49:24 PM Subject: [RBASE-L] - RE: Sub Report Question: Linking Column Names From: "John Docherty" < <mailto:[email protected]> [email protected]> To: <mailto:[email protected]> [email protected] Cc: Bruce, As far as I am aware you must have a common column name in the main report and all tables or views in the sub-reports to be able to access the data from the sub-report tables. (At least that is the way I use sub-reports. They are a very useful feature.) Regards, John Docherty From: <mailto:[email protected]> [email protected] [mailto: <mailto:[email protected]> [email protected]] On Behalf Of Bruce Chitiea Sent: Tuesday, 23 February 2016 11:40 a.m. To: <mailto:[email protected]> [email protected] Subject: [RBASE-L] - Sub Report Question: Linking Column Names All: Must the key column of the sub report table have the same name as the parent key column? Bruce SafeSectors, Inc. 909.238.9012 mobile
