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.
