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

How to link two queries using fields from different tables

rbuserrbuser
edited February 2009 in DADE
ReportBuilder 10.09
Delphi 2007

Hi,

In a report built with an "enduser solution", I need to create a query (QA)
and link it to another (QB) with two fields.
In both queries I have two fields from different tables.
RBuilder let me link from QA using only the fields that come the first table
in the query (the root):
I can choose any field in QB, but in QA only those that come from the
root table.

I cannot avoid this because of the logic of the report.
How can I solve this?

I tried to modify manually the SQL (with Edit SQL), but I lost all links and
I don't know how to set them.
How can I set them?
Can I use query params and use them as I do in VCL for Master/Details?
Is changed this behaviour in RB 11?

Thank you in advance,
Massimiliano.

Comments

  • nardmoseleynardmoseley
    edited February 2009

    RB 11 includes some powerful DADE enhancements - including Linking
    enhancements. You can link on calc fields and you can edit the SQL and link.
    And there are 3 types of linking that are supported. More details here

    http://www.digital-metaphors.com/DADE/General/What's_New/RB_11/DADE

    Main RB 11 What's New page...

    http://www.digital-metaphors.com:8080/General/What's_New/RB_11


    Here is a rbWiki 'How To' for manually linking DADE piplines - this would
    work for RB 10

    http://www.digital-metaphors.com/rbWiki/DADE/Linking_Dataviews/How_To...Manually_Link_DADE_Pipelines



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited May 2009
    Hi,

    I bought and installed the new version, but I can't find a solution to my
    problem that was:

    In a report built with an "enduser solution", I need to create a query (QA)
    and link it to another (QB) with two fields.
    In both queries I have two fields from different tables.
    RBuilder let me link from QA using only the fields that come the first table
    in the query (the root):
    I can choose any field in QB, but in QA only those that come from the
    root table.

    I cannot avoid this because of the logic of the report.
    How can I solve this?

    I tried to modify manually the SQL (with Edit SQL), but I lost all links and
    I don't know how to set them.
    How can I set them?
    Can I use query params and use them as I do in VCL for Master/Details?

    Can you help me please?
    Thank you in advance.

    Massimiliano Trezzi.




This discussion has been closed.