Blank Field in Main causes all of Sub records to print

rbuser

I have a (relatively) simple report
where the main report data (households) is sorted by postal code.

A sub-report links to the main dataset via a key
something like:

Households Individuals

HH_Key -----------| Ind_Key
HH_Surname |-------HH_Key
HH_PostalCode Ind_Name
etc. etc.

It works fine... unless the postal code is blank
In this case, all of the individuals whether linked to
the master record or not are printed for each household.

A simple problem that I just can't understand. If I
filter out the blank postal codes, it works.

Any insights would be appreciated.

Jon

nicocizik

Hi Jon,

Check out the SkipWhenNoData property of your detail datapipeline. Setting
this to true should prevent the records from printing when the master field
is empty.

--

rbuser

> Check out the SkipWhenNoData property of your detail datapipeline.

The master record exists (and I want to print it). Only the postal
code is missing (the sort field).

The field in question is not the linking field... it is just the
sort field for the master data.

I should have mentioned that I am using the user designed reports.

I've set the option (link) to
"Include all records from Households (the master) regardless
of whether....."

The master record with the missing postal code does have a link to
an individual record.

Jon