Using Subreport to bring in four fields into Main Report

buggy's Avatar, Join Date: Mar 2011
Newbie Member
I have a report that is running a query that limits the data based on the information from the control form. On the bottom of this report, I have been asked to pull in totals for (4) fields based on a different table and criteria. The values needed run correctly from the query.

The main report is rptCCE Employee Development Report - Directors
The main Query for this report is qryCCE Employee Development Report - Director.

The report called rptDegreeBydirector uses a query called qryDegreeByDirector.

I have tried unsuccessfully to encorporate rptDegreeByDirector as a subreport to rptCCE Employee development Report - Directors.

What am I doing wrong? A copy of the master database is attached to this thread.

Attached Files
File Type: zip CCE Employee (158.3 KB, 15 views)
apr pillai's Avatar, Join Date: Dec 2010
Go4Expert Member
Both the reports in question copied and modified with the suffix 2.
  1. rptCCE Employee Development Report - Directors2
  2. rptDegreeByDirector2

The corrected database is attached.
  • The main correction I have made on the sub-report is shifting the report controls from the Page Footer to the Detail Section.
  • The Sub-Report is inserted as a Sub-Report into the main Report Footer.
Attached Files
File Type: zip CCE Employee (104.5 KB, 5 views)
jitendraets's Avatar
I am new, can you guide me here