Bruce:
I am so glad that you found this feature useful!
Pleasure is mine, as always.
Very Best R:egards,
Razzak
At 02:32 PM 4/14/2017, Bruce Chitiea wrote:
R:azzak:
THAT is hot!
For those of us trafficking in one-off crunching jobs with deadlines
measured in hours TODAY, this is a gift!
Thank you,
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 4/13/2017 9:41:24 PM
Subject: [RBASE-L] - Tip of the Day: Custom Table Relationships in
the Report Designer
From: "A. Razzak Memon" <[email protected]>
To: [email protected]
Cc:
Friday, April 14, 2017
Tip of the Day: Custom Table Relationships in the Report Designer
Product.......: R:BASE X/X Enterprise (Version 10)
Build.........: 10.0.2.20411 or higher
Section.......: Reports
Keywords......: Relational Design, Column Linking, Table Relations
Have you even began development on a new report with a SubReport and
experienced the
issue where slave table data does not appear?
Whether from non-relational design or legacy database migration,
extra sets of "common"
columns will disrupt the relational display of slave table data on
the SubReport.
An easier solution to modifying the table and column structure is to
utilize a Custom
Table Relationship for the multi-table report.
Custom Table Relationships is a new feature within R:BASE X/X
Enterprise for multi-table
forms, and has just been implemented reports as well, allowing for
custom column linking
to be defined between tables. By default, R:BASE assumes table
relationships are based
upon common column names, but the scenario is not always the case
for all databases.
Custom Table Relationships are available for multi-table
forms/reports to set specific
column links between tables. The interface provides a natural method
to click and drag a
column name to another column name for creating links.
Links between tables can be customized if common field names or
primary/foreign key
relationships were not used in the database design, or if some other
purposeful convention
is used between tables. Custom links between the tables would be
based upon the columns
with the one-to-many or many-to-many relationships.
Covering all aspects of Custom Table Relationships for forms and
reports is available within
the "Custom Table Relationships" technical document:
http://www.razzak.com/fte/
One of the most important aspects in business growth is your company
data, and no one else
has more invested in your success than R:BASE Technologies. Invest
forward with R:BASE!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
-- 34 years of continuous innovation!
19 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
-- You received this message because you are subscribed to the
Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
