Microsoft Access 2010 Report / Sub-report display problem

Dear Experts;

I have a problem with a sub-report only appearing in one grouping of a main report when the underlying data is there and should be forcing the display. See the attached document which provides the necessary details. I appreciate any help. It's probably something silly that I'm missing.
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Eileen MurphyIndependent Application DeveloperAuthor Commented:
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
What is the master and child linking fields for the sub report thta is not working?
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
It is working for the one group but not the other. I highlighted the fields on the document I uploaded.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Unfortunately, the document you upload really does not help a lot. We need to see a lot more like the properties or the sub report.

So I will ask again:
Please tell us what are the master and child linking fields for the sub report that is not working?

TIP: For the fastest help, attached a sample database.
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
OK -- I'll make a sample db - I'm bound by confidentiality -- thanks.
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Interesting..... I pulled all the necessary components into a new db and the report is working. I am going to pull everything else into this db to see if somehow the orig db became corrupted or something. This is infuriating. I'll keep you posted. Thank you.
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Hi all -- I want to tell you what I wound up doing in order to fix this -- the problem did seem to rectify itself when I created a new db but recurred when I imported the rest of the application components into the new db. For some reason having a boolean value as a master/child criteria on the subform -- the results were not consistent. So -- I added a field to the subforms where iif(boolean value = 0, "A","B") and used that value as the master/child value -- and voila! Not sure what the difference is -- but this worked.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
I am not surprised that the issue was in the master/child linking fields. That is why I was asking about those specific properties.  Glad I could point you in the right direction. Sad you don't feel that deserved any credit (points)

Glad you got it sorted out.
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
I figured it out.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.