SubReport - Lined Up with Main Report Detail - Repeats any Multivalues??!?!?!

  • Thread starter Thread starter misscrf
  • Start date Start date
M

misscrf

I searched the threads, but did not find this particular problem.

I have a main report. It is based on a query as follows:

Customer Table

1 to many relationship with

Orders table

In the main report, I put the customer name and address, and the Order
Date from the Orders table.

Now, I also have a subreport.

This is based on a table called
Order Types.

They are the types of orders that a given customer is to receive.
Another one to many with Customer's table.

I line the subreport up with the fields on the main report, so that it
will look like this:

Customer Order Date Order Types
Mary Smith 1/1/2007 A type
B type
D type
John Doe 2/2/2007
Amy Clark 3/3/2007 B type

It works for all customers that have 1 order type, or no order types.
I get to a customer that has multiple order types. It lists the three
types, then it list them 3 more times. Then the next customer is
listed. It looks like this:

Customer Order Date Order Types
Mary Smith 1/1/2007 A type
B type
D type
A type
B type
D type
A type
B type
D type
A type
B type
D type
John Doe 2/2/2007
Amy Clark 3/3/2007 B type

Why is this happening?

:-(

Thank you for any help you may be able to give.
 
misscrf said:
I searched the threads, but did not find this particular problem.

I have a main report. It is based on a query as follows:

Customer Table

1 to many relationship with

Orders table

In the main report, I put the customer name and address, and the Order
Date from the Orders table.

Now, I also have a subreport.

This is based on a table called
Order Types.

They are the types of orders that a given customer is to receive.
Another one to many with Customer's table.

I line the subreport up with the fields on the main report, so that it
will look like this:

Customer Order Date Order Types
Mary Smith 1/1/2007 A type
B type
D type
John Doe 2/2/2007
Amy Clark 3/3/2007 B type

It works for all customers that have 1 order type, or no order types.
I get to a customer that has multiple order types. It lists the three
types, then it list them 3 more times. Then the next customer is
listed. It looks like this:

Customer Order Date Order Types
Mary Smith 1/1/2007 A type
B type
D type
A type
B type
D type
A type
B type
D type
A type
B type
D type
John Doe 2/2/2007
Amy Clark 3/3/2007 B type
Click to expand...


It sounds like the main report's record source query has a
Join to the types table. If so, remove that table from the
query.
 
Back
Top