PC Review


Reply
Thread Tools Rate Thread

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

 
 
J Lines
Guest
Posts: n/a
 
      16th Sep 2003
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?

 
Reply With Quote
 
 
 
 
Duane Hookom
Guest
Posts: n/a
 
      16th Sep 2003
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" <(E-Mail Removed)> wrote in message
news:4ab201c37bf7$49cf8060$(E-Mail Removed)...
> 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?
>



 
Reply With Quote
 
J Lines
Guest
Posts: n/a
 
      16th Sep 2003
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" <(E-Mail Removed)> wrote in message
>news:4ab201c37bf7$49cf8060$(E-Mail Removed)...
>> 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?
>>

>
>
>.
>

 
Reply With Quote
 
HSalim
Guest
Posts: n/a
 
      16th Sep 2003
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" <(E-Mail Removed)> wrote in message
news:081e01c37c06$04c82760$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> >news:4ab201c37bf7$49cf8060$(E-Mail Removed)...
> >> 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?
> >>

> >
> >
> >.
> >



 
Reply With Quote
 
j Lines
Guest
Posts: n/a
 
      16th Sep 2003
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" <(E-Mail Removed)> wrote in message
>news:081e01c37c06$04c82760$(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> >news:4ab201c37bf7$49cf8060$(E-Mail Removed)...
>> >> 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?
>> >>
>> >
>> >
>> >.
>> >

>
>
>.
>

 
Reply With Quote
 
HSalim
Guest
Posts: n/a
 
      16th Sep 2003
OK. Then Duane's suggestion is the only way.
Regards
HS
"j Lines" <(E-Mail Removed)> wrote in message
news:3cb101c37c0f$81f533f0$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> >news:081e01c37c06$04c82760$(E-Mail Removed)...
> >> 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" <(E-Mail Removed)> wrote in message
> >> >news:4ab201c37bf7$49cf8060$(E-Mail Removed)...
> >> >> 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?
> >> >>
> >> >
> >> >
> >> >.
> >> >

> >
> >
> >.
> >



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display Child Records in subform Zorkmid Microsoft Access Forms 7 22nd Sep 2009 10:20 AM
Need to copy parent-child-child records (re: Allen Browne's metho Dr Steevil Microsoft Access 5 20th Feb 2009 03:46 AM
Child/Master link set up but child records not showing Tmarkos Microsoft Access Forms 3 9th Oct 2008 05:33 PM
Navigating parent-child relation to update the child records --- How??? Hexman Microsoft VB .NET 1 5th Oct 2006 09:21 AM
How to display data from mulple child records in single report line Tim Callahan Microsoft Access Reports 3 30th Sep 2003 02:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:46 PM.