1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Using Subreport to bring in four fields into Main Report

Discussion in 'MS Access' started by buggy, Mar 18, 2011.

  1. buggy

    buggy New Member

    Joined:
    Mar 18, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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.

    Thanks.:crazy:
     

    Attached Files:

  2. apr pillai

    apr pillai New Member

    Joined:
    Dec 17, 2010
    Messages:
    16
    Likes Received:
    12
    Trophy Points:
    0
    Occupation:
    Auditor
    Location:
    India
    Home Page:
    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:

  3. jitendraets

    jitendraets Banned

    Joined:
    Jun 14, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    hi,
    I am new, can you guide me here
     

Share This Page