Thank you to all on the list, and to R:BASE Support!
Bottom Line: Success
Both the "View Approach" and the "Temp Table Approach" worked in the
end.
Turns out, this has been a gut-level tutorial in distributing columns
and SubReports correctly across Break Headers.
My bad, and another testament to the integrity of R:BASE and the rbase-l
community.
Hats off!
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
------ Original Message ------
Sent: 2/24/2016 7:09:07 AM
Subject: Re: Sub Report Question
From: "R:BASE Support" <[email protected]>
To: "Bruce Chitiea" <[email protected]>
Cc:
Dear Bruce,
Thank you for your email.
We have also monitored the responses you have received on the RBASE-L
list.
The answer to your issue may be in the table relationships.
Since it appears you have no duplicate common column names between the
tables,
you may find your desired results by creating one or more views to
replace the
current table relationships for this report.
Perhaps combine Table 1 and Table 2 into a view, then define SubReports
for
Tables 3 and Table 4.
Best regards,
Support Team
R:BASE Technologies, Inc.
P: 1+724.733.0053
E: [email protected]
http://www.rbase.com
http://www.facebook.com/rbase
At 11:58 PM 2/22/2016, Bruce Chitiea wrote:
All:
I have a four table report which by and large is successful, just that
SOME of the values in the fourth table to not appear in the report.
Linkages
Table 1 < Sub-Table 2
Table 2 < Sub-Table 3
Table 2 < Sub-Table 4
The key columns of all tables align correctly, but half the values in
Table 4 do not appear. The values which do appear all relate correctly
to their parents.
In the attached example page, there are two phone numbers in Table 4
for #40041: Castorena, Sam. These do not appear. I've taken care that
the fields do not cross the right margin.
Without jumping into the "deep weeds", is there any generic condition
which might cause this?
Thanks for any perspective,
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
