Subreport/ Subform not showing up in Main Report

Posted on 2009-12-31
Last Modified: 2013-11-28
I have a report with a subreport in the report footer. I see the outline of the subreport in the report footer in report view. I can even see the labels but I do not see the text boxes or the values in them.
All I need to do is to have the subreport values show up in the report footer from the subreport. (The values come from a different query than the query for the main report.)

My question is: Is there a setting that I need to set to have the values show up? As I said I see the subreport, just no values are showing.

Thank you in advance.
Question by:jonsuns7
    LVL 46

    Expert Comment

    Make sure you have the reportfooter & subreport as can grow

    LVL 31

    Expert Comment

    If you open the subreport separately, do you see the values?

    Expert Comment

    I think you should link the master and child field.

    Accepted Solution

    I was able to solve it. I actually unlinked the Master and Child fields. I only needed to have the subreport's values be visible, I could see the report, but only the labels appeared and an outline of the subreport.

    Once I unlinked the values everything appeared in report view.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now