Subreports show up blank

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
 
N

NetworkTrade

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
 
L

LoboNetwork

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

NetworkTrade

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?
 
L

LoboNetwork

Thanks NetworkTrade

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top