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

J

J Lines

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

Duane Hookom

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

J Lines

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

HSalim

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

j Lines

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
 

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