Sub Reports Duplicating Data

[Guest]

There was an earlier post dated 10/04 where the question was why are the sub
reports duplicating the data? The response was to check the Child/Master
fields on the sub reports. I don't understand what this property has to do
with creating a sub report. I have two reports that are included as sub
reports and the data is getting duplicated. What properties should be used
in the Child/Master fields to avoid the duplicate data?

Thanks,
Frank

 

[Duane Hookom]

The link master/child will limit the display of records in the subreport to
records with a specific value in a field matching the main report.

I would also check the record source of the main report to see if you are
including a level of detail that should be only used in the subreport. For
instance a report of orders might have the OrderDetails in a subreport. The
OrderDetails should not also be included in the main report.

 

[Guest]

But the main report only contains the two sub reports in the detail section,
no other controls. There is no other data except the report header and page
footer. When viewing the sub reports individually, there is no duplication.
It only duplicates inside the sub report.

Maybe if I describe what I'm trying to accomplish, that might help...I have
two reports based on two different queries. One query is for the top 10
sales for ABC Revenue for each sales area (East and West), the second query
is for the top 10 sales for DEF Revenue (also East and West). Since I can't
apply the Top Values property on two separate controls in a single query, I
had to create the two.

Now what I'm trying to do is combine those two queries into one report, but
the data for both queries are duplicated when running the main report.
Unless there is a way to point a single report to two different queries, I
have to create the two individual reports, then use them as sub reports into
the main report.

Hope that makes sense.
Thanks,
Frank

 

[Duane Hookom]

Does your main report have a value in the Record Source property?

You might be able to create a union query from your "two different queries"
and use the union query as the record source of a main report (no
subreports).

 

[Guest]

Yes, it's pointing to one of the two queries. If I change it to point to the
underlying table, the report times out.

I'm not familiar with union queries, but if that's the best solution, I'll
have to learn.
Thanks.

 

[Duane Hookom]

Try remove the record source of the main report.