Master with 2 detail datasets

rbuser

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

digitalmetaphors

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