SubReport Problems

[Guest]

Hello All:
I am trying to write a report for an application I am creating part of which
is to track how many prospects were seen on any one particular date and
additionally how many customers on that same date. I have this information
stored in tblCalls which consists of the CallID, CustomerID, CallDate,
CallResults and Comments. The main report will be based on the CallDate.
The subreport has Master and Child links set to CallDate. The problem is
when the subreport is added to the detail section of the main report I
receive too many pages. The records are repeated on multiple pages. This
behavior does not happen when the subreport is run alone but only when it is
on the main report. Does anyone have an idea why these records are repeated
in this manner? Any ideas will be greatly appreciated.

Barry

 

[Duane Hookom]

You have described only one table so I am a bit confused why you are using a
subreport. I expect the Record Source of your main report needs to be
something like:

SELECT DISTINCT CallDate
FROM tblCalls;
or
SELECT CallDate
FROM tblCalls
GROUP BY CallDate;