Master-Detail Field Link Designer

thompson77thompson77
edited 10:20PM in FastReport 4.0
Hi,

I have 2 SQL queries (in frxDBDataset1 and frxDBDataset2) and want to link them for a master-detail report. In the documentation of FastReport on page http://www.fast-report.com/documentation/UserMan/4.htm there is a Field Link Designer pictured to link the table columns between master and detail table. But I cannot find this Field Link Designer.
Can you give me a hint how I can set the link for master-detail?

Best regards,
Thomas

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 10:20PM
    you can't find it because you are using external data sets not internal datasets.
    connect your sql queries by setting the properties in your sql component.
  • stewag25stewag25
    edited 10:20PM
    I have the same problem.
    I guess gordk means to buid a left outer join query but to me that seems against the logic of a sub-band.

    I have a table with articles and a table of article-photos. There can be several photos to one article.
    So If I build an sql view, I will have n entries of an article, if there are n photos of the article.

    This would result in multiple lines in the master.
    What I want is only one master per article and n subdetails.

    ?
  • gpigpi
    edited 10:20PM
    Reopen detail dataset in the master's OnAfterScroll event on the Delphi's level
  • stewag25stewag25
    edited June 2017
    gpi wrote: »
    Reopen detail dataset in the master's OnAfterScroll event on the Delphi's level

    @gpi: well THAT is a good idea, let's see...

    ... WORKED. Thank you!

Leave a Comment


Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2025