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

Master with 2 detail datasets

edited November 2002 in DADE
Hi there, Im using RB7 Ent with D6 Ent.


When I link a detail dataset to a master one using the data designer, there
is an option to include reocrds from the master only if they exist in the
detail.

I understand how this works when there is a single detail dataset linked to
the master dataset. What happens when there are 2 detail datasets linked to
the master dataset?

If for example M1 D1 and D2 are the tables

D1 and D2 are both linked to M1 with the option ( only show records from M1
...) Will the master record be hidden if either of the details is blank or
only when both of them are blank ?


I'm asking this because I have situation where the user can specify filter
conditions at run time against any of the datasets used by the report and I
would like to give them the option to specify the "only show master when
blank" or not when filtering their data. So in essence I need to know the
logic used when a Master dataset has multiple Detail datasets - possibly
with different settings for the "only show master when blank" link options.


Cheers,
Ben

Comments

  • edited November 2002
    This is a visual way to set the datapipeline's SkipWhenNoRecords property.
    When you have multiple details, two in this case, and SkipWhenNoRecords is
    set to true, then the master should print when there is at least one record
    in either detail dataset. When one detail dataset is empty, it will not
    cause the master to be skipped when the other detail has data.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.