Subreports show up blank

  • Thread starter Thread starter LoboNetwork
  • Start date Start date
L

LoboNetwork

Hi

I have a master report containing three subreports. When i open the
individual subreports, they display correctly. When I open the master report
in print preview, the subreports come out blank. But the page numbers match
the number that should theorethically be there. It is as if the data is
there but just not visible (and the visible fields for everything are set
True).

The subreports get data from their own queries.
The master report has its own query to allow for proper sort.
The sourcing seems to be right and the child/masters were automatically dont
by access based on my relationships and look right in theory.

Does anyone know why the subreports appear blank? All I see is the page
header and footer of the master report.

Regards,
Lobo
 
troubleshoot; delete/add one of them as a new subreport ; but this time be
sure you select the link between parent/child....rather than accept the
default
 
Heyas,

I have tried this and it does not work. I've tried manually setting the
parameters, the relationships, etc. I've been troubleshooting for hours.
The individual reports work well on their own... I dont get it....hmm.
 
the subreport, standalone, can work fine

but a subreport inserted in a main report, by definition, is showing only
the data that cross references to the main report; and when a subreport has
no data at all -it will be blank

thus it is most probable, based on your symptom, that the cross reference
coming from the main report i.e. display info of record X - - - and there is
no data in the subreport corresponding to a value of X .....so presuming a
misunderstanding of the cross referencing fields between main and sub is the
first suspect

is the subreport sourced on a query? have you tried the query standalone -
is it showing a value consistent with the record being set in the main report?
 
Thanks NetworkTrade

The problem was related my query being setup incorrectly and as a result
having incorrect Master/Child Fields.
 
Back
Top