Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Master-Detail pipelines

edited January 2002 in General
Hi. I am using RB 6.03 Enterprise and programming in RAP. I am using a
Master-Detail setup through my pipelines since I am reporting from a text
file. For each MASTER record that is traversed in the report, I want to
check to see if there are DETAIL records for the MASTER. A detail count
property or a boolean value would be great. Is there a way to do this using
RAP? Thanks in advance.

Brian Kennedy
RB 6.03 Ent.

Comments

  • edited January 2002
    The following may only work if the SkipWhenNoRecords property is false on
    the detail dataset.

    If you are using Delphi query linking, you should be able to check the
    record count of the detail dataset.

    If you are using DADE query linking, then the detail dataset includes all
    details for all maters, and you'll have to check the linking field value of
    the current detail record to see if it matches the current master record.

    From RAP, you should be able to access the datapipelines directly. For the
    subreport datapipeline, call Subreport1.Datapipeline['myLinkFieldName']


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.