Problem with report with three subreports

I have a report which contains 3 subreports.  The 3 subreports each have a separate query as their record source.

The reports are all use HeaderRecID as the link Master field and Child master field.

The problem I'm having is....  if the first 2 subreports have no data then the 3rd subreport will not print and I can't figure out why.

--Steve
SteveL13Asked:
Who is Participating?
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.

SteveL13Author Commented:
And by the way, if I run the 3rd subreport by itself it print previews just fine.
0
Jeffrey CoachmanMIS LiasonCommented:
What's special about the third subreport?

What I mean is, ...what if Subreports 1 and 3 had no data, ...would subreport 2 also not print?
0
Eric ShermanAccountant/DeveloperCommented:
>>>>>The reports are all use HeaderRecID as the link Master field and Child master field.>>>>>

You should have a separate query that has every unique HeaderRecID included as the RecordSource of your Main report.   Then three individual queries to supply your different sub-reports.

Sounds like you have some records that would be selected for the third report but there is nothing to link them to on the main report.

ET
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
Jeffrey CoachmanMIS LiasonCommented:
This is why a sample is always helpful...

How are these reports related Hierarchically?
Like this:
MainReport
    SubReport1
        SubReport2
            SubReport3

Or like this:
MainReport
SR1 SR2 SR3

If like the first, then your linking may not be correct as each subreport needs to link on the PK of the report above it

If like the second, then more info on these reports is needed, as this works fine for me...

JeffCoachman
0
SteveL13Author Commented:
The clue was...

"You should have a separate query that has every unique HeaderRecID included as the RecordSource of your Main report"

Thanks.
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.