subreport enigma

[anon]

I have a master report with two subreports. Both are linked to the master by
the same two fields, a date and a number. The subreports do not appear with
the master report is opened. Both reports will open on their own and I am
sure the Master Child relationships are correct (the field names were
selected from the drop-down menus). What could be causing this problem? I
have tried deleting one of the subreports and the same thing happens. One
hint that might help: Although the "can shrink" properties for both
subreports are set to yes, the master report still leaves one blank line for
each subreport. What gives?

 

[Ken Snell [MVP]]

You need to tell us the SQL statements for the main report's recordsource
query and for the two subreports' recordsources. Identify the fields that
you're using as the linking fields between the main report and the
subreport. Post exactly what is in the Link Master Fields and Link Child
Fields properties for the report.

When the subreports don't show, does the main report have any displayed
data?