John,
Thanks, I was hoping you'd say that.
My last email to R:azzak touches on that common column/values question.
In my case, common column names and ALL data values down at slave levels
1, 2 and 3 all match up, but only some of the matching values show up at
slave level 3.
NO rows appearing I could easily fix; SOME appearing ... ?
Bruce
BTW: You in Rotary down there?
------ Original Message ------
Sent: 2/23/2016 12:59:08 PM
Subject: [RBASE-L] - RE: Sub Report Question: Linking Column Names
From: "John Docherty" <[email protected]>
To: [email protected]
Cc:
Bruce,
No that should achieve the same result.
In my experience the key is to have the linking (common) column with
matching data in that column for all of the tables involved. (If the
data is not the same the rows(obviously) won’t appear.) I haven’t had
a chance to look at your nesting in detail but I suggest you try
modifying the tables to take the one column through all of the tables –
a view may allow you to do that more easily.
Regards,
John Docherty
From:[email protected] [mailto:[email protected]] On Behalf Of Bruce
Chitiea
Sent: Wednesday, 24 February 2016 9:44 a.m.
To:[email protected]
Subject: [RBASE-L] - RE: Sub Report Question: Linking Column Names
John:
For this report I'm using discrete temp tables at each SubReport level
in lieu of views.
Any practical difference?
Bruce
------ Original Message ------
Sent: 2/23/2016 10:14:14 AM
Subject: [RBASE-L] - RE: Sub Report Question: Linking Column Names
From: "John Docherty" <[email protected]>
To: [email protected]
Cc:
Bruce,
If you have issues with column names and values that don’t match in the
various tables, (and hence don’t appear) you might want to consider
using views so that you can just select the data you want to include in
the reports. (That may save having to change column names in the
tables.)
Regards,
John Docherty
From:[email protected] [mailto:[email protected]] On Behalf Of Bruce
Chitiea
Sent: Wednesday, 24 February 2016 3:59 a.m.
To:[email protected]
Subject: [RBASE-L] - RE: Sub Report Question: Linking Column Names
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
