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.
