Sub Report With No Links to Parent Not Visible in preview/print mo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've not attempted this before but I now have a need to display an
unconnected subreport with data on a report where there is no linking
criteria.

The subreport is actually an index for the main report but since it is
effectively a summary shares no common linkable field with the main report.
I want to drop it onto the report footer.

Any ideas?
 
Dial222 said:
I've not attempted this before but I now have a need to display an
unconnected subreport with data on a report where there is no linking
criteria.

The subreport is actually an index for the main report but since it is
effectively a summary shares no common linkable field with the main report.
I want to drop it onto the report footer.
Click to expand...


Is you question about how to drop a subreport into a main
report's footer? If so, just do it and make dure the Link
Master/Child properties have nothing in them.
 
Not quite, I can place the sub report onto the main report's footer without
any problem, however the sub report does not display any of it's data.
Presumably becuase there is no link between them?
 
You did say the subreport's data was independent of the main
report data, right? If so, then setting the Link
Master/Child to nothing will let the subreport process all
records in its RecordSource table/query. If the subreport
is empty, it's because its RecordSource table/query produces
an empty data set.

I guess the next question is when/how is the data for the
subreport generated. If it's being created while the main
report is being processed, maybe it was not finalized
properly before the subreport is first encountered???
 
Back
Top