Subreport showing up multiple times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to prepare a statement Report from three tables, Payments,
Clients and Customers. I have the header portion of the report based on the
particular client i am Invoicing the statement. The detail section is made up
of two subreports.

1. Owed to Client from customer
2. Owed from Client to customer

Footer calculates the difference of the two sub-reports and gives a balance
due.
reports are based on 3 queries and I am in inner outer right left mess right
now. Mathmatics work right in the footer so the amounts aren't duplicated but
I am getting Multiple SubReports of the exact same information if their are
more than one customer in the subreport.

I have gone back and forth so many times with the properties i am crosseyed.
In Query view their are no duplicates so I don't think its the queries?

I will pay dearly for a solution if you would find it in your heart to help
me.

More info...
I checked the master child links and verified they are valid links. master
Link is based on the qryStatement and is using the tblClients.cliContactID
field matched to Child Link based on the qryClientStatementAtClient Query and
the child field tblClients.CliContactID field. Is this sounding right? What
happens is the statement prints the right Client info in the Page header and
the detail information is repeated the number of records that are in the
subreport. If their are 5 payment transactions the subreport prints 5 times
on the statement. The subtotal that is based on the difference of the
subreports calculates correctly in other words its not adding the totals of
the 5 different subreports. Argh...
 
Without attempting to decipher all of this, I think your issue may be that
you have included more than just the Client table. You don't want to include
details in the main report that are included in the subreports (unless the
related tables are only summarized by Client).
 
wow, YOU WERE RIGHT ON THE MONEY, WORKS LIKE A CHAMP NOW.

But, :) now I have a whole bunch of Zero balances. How do I filter the
Client list without making a reference in the query to the Payments table.

-Dan
 
You can create totals queries to calculate balances by client. These should
be grouped only by client. You can then add this query(s) to your report's
record source and filter out the records you don't want to print.
 
Back
Top