Having Sub Report search constraints limit main report data

rbuser

Hello,
We are using ReportBuilder Enterprise Edition version 7.03. Yeah I know
it's old.

I have two subreports. Each with one of it's fields serving as a search
contraint. I have the constraint set to autosearch. Each of the
subreports are linked to the main report using option one whereby only
records from the main report are returned if they have matching data in
the subreport. When a particular criteria is selected and no data exists
in the subreport that matches that criteria selection the link to the
main report should result in no data as no data is returned in the
subreport. Instead I am seeing data from the main report but nothing
from the subreport. If the link used indicates an inner join to the data
set of the main report any search criteria used in the subreport should
limit the rest of the report.
So my question is, how do I set up search criteria constraints in
subreports to ensure that it restricts the data of the main report?

Thanks.
Joe

nicocizik

Hi Joe,

If you are using DBPipelines, be sure the SkipWhenNoRecords property of the
detail pipeline is set to True. This will skip the master record if there
are no detail records returned.

If you are using DADE (data workspace) double click the link between your
two dataviews and be sure the top radio selection near the bottom of the
dialog is selected...

"Include only those records from for which matching records can be found"

This is essentially the same property.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com