No other common column names, but I'm rethinking the link across all
tables to the main table per Dan Goldberg.
Bruce
------ Original Message ------
Sent: 2/23/2016 6:41:00 AM
Subject: [RBASE-L] - RE: Sub Report Question: Linking Column Names
From: "Buddy Walker" <[email protected]>
To: [email protected]
Cc:
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]
To: [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 <[email protected]>
To: karentellef <[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" <[email protected]>
To: [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:[email protected] [mailto:[email protected]] On Behalf Of Bruce
Chitiea
Sent: Tuesday, 23 February 2016 11:40 a.m.
To:[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
