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

Master-detail and SubReports doesn't work

rbuserrbuser
edited March 2004 in General
Hi,

I have 3 JITPipelines - one as master and two for details. Master has
field ID (integer) and each detail pipeline has MasterID field.
Pipelines are linked using visual designer.
In report I have some fields from master pipeline and then two
subreports - one for each detail pipeline.
Now the problem is that for some reason one detail subreport prints
whole punch of records for wrong master record (it is 8th master
record but I don't think it is important). I also output the ID and
MasterID fields and they are different, yet subreport prints them...
any idea what is wrong?

BTW It is possible that there is no records for given master in one or
both details.

I'm using D 5.1 Pro and RB 7.03 Pro

TIA
ain

Comments

  • nicociziknicocizik
    edited March 2004
    Hello,

    Please send an example of this behavior in .zip format to
    support@digital-metaphors.com and I'll take a look at it for you.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • rbuserrbuser
    edited March 2004
    On Wed, 24 Mar 2004 08:54:22 -0700, "Nico Cizik \(Digital Metaphors\)"
  • nardmoseleynardmoseley
    edited March 2004

    ----------------------------------------------------
    Tech Tip: Use Master/Detail JITPipelines
    ----------------------------------------------------


    To use Master/Detail relationship with the JITPipeline:


    1. Check out the demo dm0139 in the main demo reports app
    for an example.

    2. Make sure you have the Detail JITPipeline.MasterFieldLinks
    defined to specify the relationship. In dm0139 the detailed it
    linked to the master using the CustNo field from each pipeline.

    3. Once you have things setup like the above, then you will need
    to connect the Report.DataPipeline property to the master JITPipeline
    and the SubReport.DataPipeline property to the detail JITPipeline.

    4. In the FormCreate event set each JITPipeline.RecordCount
    property to the total number of records for each.


    You should not need to reset anything.

    6. ReportBuilder expects the data in the detail dataset
    to be in sorted order of the field links.

    In dm0139, the linked field is the CustNo, therefore
    the detail data must be order like this:

    CustNo OrderNo
    ------ -------
    1 001
    1 002
    1 003
    2 010
    2 009
    2 005



    --
    Tech Support mailto:support@digital-metaphors.com
    Digital Metaphors http://www.digital-metaphors.com



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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited March 2004
    On Thu, 25 Mar 2004 09:23:51 -0700, "Nard Moseley \(Digital
This discussion has been closed.