Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Relationship Problem

rbuserrbuser
edited February 2004 in End User
When, setuping my data dictionary, i used the option Generate to
automatically load the relationships to the table rb_join.

But, this option generates all the relationships wrong, because it
instead of be verifying in this process the constrains, it had verified the
match fields.

Does anyone understood what i mean ?

Any help?

Marcelo

Comments

  • nardmoseleynardmoseley
    edited February 2004

    Correct, the DataDictionaryBuilder performs a very simplistic field
    matching.

    You may want to write some custom code to populate the join table entries
    based upon some more sophisticated criteria.



    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited February 2004
    Considering how complex that can be, does anyone have a example how to
    do it?

    Any help please,

    Marcelo


  • nardmoseleynardmoseley
    edited February 2004
    Yes, it is a complex problem. The criteria used to generate meaningful joins
    is going to vary based upon the techniques used by the designer/creator of
    the database tables, the meaning behind the data, possibly even the database
    product used.

    Defining the joins should be a one time task, therefore you might consider
    manually popuplating the jions table. Write some code that adds each record
    or use the DataDictionaryBuilder's data entry screen for the Joins..

    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.