How can I force the subreports to display if there are no child records?

I have main report with 3 linked sub reports, as expected
when there are child records in the corresponding tables
report details are displayed. However when there's no
corresponding record the subreport details (labels and
blank fields) are not displayed. This leaves my main
report with large white spaces and labels missing which
are required within the final report.

How I can force subreports to display if there are no
child records?

Place the labels/column headings in the main report. I don't believe you can
make a subreport display if there are no records.

--
Duane Hookom
MS Access MVP


"J Lines" <jlines@fesa.wa.gov.au> wrote in message
news:4ab201c37bf7$49cf8060$a601280a@phx.gbl...
> I have main report with 3 linked sub reports, as expected
> when there are child records in the corresponding tables
> report details are displayed. However when there's no
> corresponding record the subreport details (labels and
> blank fields) are not displayed. This leaves my main
> report with large white spaces and labels missing which
> are required within the final report.
>
> How I can force subreports to display if there are no
> child records?
>

Thanks for your help Duane. I was trying to avoid that,
seems long winded way to handle the task!

>-----Original Message-----
>Place the labels/column headings in the main report. I
don't believe you can
>make a subreport display if there are no records.
>
>--
>Duane Hookom
>MS Access MVP
>
>
>"J Lines" <jlines@fesa.wa.gov.au> wrote in message
>news:4ab201c37bf7$49cf8060$a601280a@phx.gbl...
>> I have main report with 3 linked sub reports, as
expected
>> when there are child records in the corresponding tables
>> report details are displayed. However when there's no
>> corresponding record the subreport details (labels and
>> blank fields) are not displayed. This leaves my main
>> report with large white spaces and labels missing which
>> are required within the final report.
>>
>> How I can force subreports to display if there are no
>> child records?
>>
>
>
>.
>

What do you want it to display?
Wouldn'y you rather set the canshrink property to true and reclaim the white
space?
also, another trick is to make the subreport control as smal as possible,
and let it autogrow

HS

"J Lines" <jlines@fesa.wa.gov.au> wrote in message
news:081e01c37c06$04c82760$a301280a@phx.gbl...
> Thanks for your help Duane. I was trying to avoid that,
> seems long winded way to handle the task!
>
> >-----Original Message-----
> >Place the labels/column headings in the main report. I
> don't believe you can
> >make a subreport display if there are no records.
> >
> >--
> >Duane Hookom
> >MS Access MVP
> >
> >
> >"J Lines" <jlines@fesa.wa.gov.au> wrote in message
> >news:4ab201c37bf7$49cf8060$a601280a@phx.gbl...
> >> I have main report with 3 linked sub reports, as
> expected
> >> when there are child records in the corresponding tables
> >> report details are displayed. However when there's no
> >> corresponding record the subreport details (labels and
> >> blank fields) are not displayed. This leaves my main
> >> report with large white spaces and labels missing which
> >> are required within the final report.
> >>
> >> How I can force subreports to display if there are no
> >> child records?
> >>
> >
> >
> >.
> >

No. The report acts as a worksheet for fire inspections
and printed out as a hardcopy for next inspections.
Existing labels within subreports i.e. after hour contact
numbers, hazards comments are required to be displayed
for the fire fighters to manually capture the information
missed during the previous inspection. If the labels are
missing there is a chance the information will never be
captured again.

Cheers,

j
>-----Original Message-----
>What do you want it to display?
>Wouldn'y you rather set the canshrink property to true
and reclaim the white
>space?
>also, another trick is to make the subreport control as
smal as possible,
>and let it autogrow
>
>HS
>
>"J Lines" <jlines@fesa.wa.gov.au> wrote in message
>news:081e01c37c06$04c82760$a301280a@phx.gbl...
>> Thanks for your help Duane. I was trying to avoid that,
>> seems long winded way to handle the task!
>>
>> >-----Original Message-----
>> >Place the labels/column headings in the main report. I
>> don't believe you can
>> >make a subreport display if there are no records.
>> >
>> >--
>> >Duane Hookom
>> >MS Access MVP
>> >
>> >
>> >"J Lines" <jlines@fesa.wa.gov.au> wrote in message
>> >news:4ab201c37bf7$49cf8060$a601280a@phx.gbl...
>> >> I have main report with 3 linked sub reports, as
>> expected
>> >> when there are child records in the corresponding
tables
>> >> report details are displayed. However when there's no
>> >> corresponding record the subreport details (labels
and
>> >> blank fields) are not displayed. This leaves my main
>> >> report with large white spaces and labels missing
which
>> >> are required within the final report.
>> >>
>> >> How I can force subreports to display if there are no
>> >> child records?
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>

OK. Then Duane's suggestion is the only way.
Regards
HS
"j Lines" <jlines@fesa.wa.gov.au> wrote in message
news:3cb101c37c0f$81f533f0$a501280a@phx.gbl...
> No. The report acts as a worksheet for fire inspections
> and printed out as a hardcopy for next inspections.
> Existing labels within subreports i.e. after hour contact
> numbers, hazards comments are required to be displayed
> for the fire fighters to manually capture the information
> missed during the previous inspection. If the labels are
> missing there is a chance the information will never be
> captured again.
>
> Cheers,
>
> j
> >-----Original Message-----
> >What do you want it to display?
> >Wouldn'y you rather set the canshrink property to true
> and reclaim the white
> >space?
> >also, another trick is to make the subreport control as
> smal as possible,
> >and let it autogrow
> >
> >HS
> >
> >"J Lines" <jlines@fesa.wa.gov.au> wrote in message
> >news:081e01c37c06$04c82760$a301280a@phx.gbl...
> >> Thanks for your help Duane. I was trying to avoid that,
> >> seems long winded way to handle the task!
> >>
> >> >-----Original Message-----
> >> >Place the labels/column headings in the main report. I
> >> don't believe you can
> >> >make a subreport display if there are no records.
> >> >
> >> >--
> >> >Duane Hookom
> >> >MS Access MVP
> >> >
> >> >
> >> >"J Lines" <jlines@fesa.wa.gov.au> wrote in message
> >> >news:4ab201c37bf7$49cf8060$a601280a@phx.gbl...
> >> >> I have main report with 3 linked sub reports, as
> >> expected
> >> >> when there are child records in the corresponding
> tables
> >> >> report details are displayed. However when there's no
> >> >> corresponding record the subreport details (labels
> and
> >> >> blank fields) are not displayed. This leaves my main
> >> >> report with large white spaces and labels missing
> which
> >> >> are required within the final report.
> >> >>
> >> >> How I can force subreports to display if there are no
> >> >> child records?
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >