can grow, can shrink with subreports; suppress with blank lines/ar

D

dlazenby

I am creating a report (for a medical database) that has multiple,
consecutive subreports in it. (BTW, it is also set up-using a command button
on the form, to print a single patient record at a time).
Each subreport's structure is somewhat similar: It is a report that consists
of:
1) a simple label in the report header (no footer), the label is 0.2 height;
the report header is 0.2 height and set to can grow-yes, can shrink-no
2) a text box with a control source set up to concatenate 3-5 fields using
the trim, & and + operators (e.g., =Trim([MedName]+" " & [MedAmt]+" " &
[MedUnit]+" " & [MedRoute]+" " & [MedFreq]+" " & [MedReason]). The textbox
(height 0.2) is set to can grow-yes, can shrink-no; the detail (height 0.2)
is set to can grow-yes, can shrink-no;
It works Ok with the subreports expanding/collapsing if each subreport has 1
or more lines; however if the subreport is blank/empty my main report will
have a blank space there with multiple blank lines.
I have stacked each subreport so that there really is no space between them.
The subreports are linked to the "main" report with the parent/child linkage.
Should I be using the IIf Null process instead of the Trim/+ route?
Please advise. Thanks.
 
M

Marshall Barton

dlazenby said:
I am creating a report (for a medical database) that has multiple,
consecutive subreports in it. (BTW, it is also set up-using a command button
on the form, to print a single patient record at a time).
Each subreport's structure is somewhat similar: It is a report that consists
of:
1) a simple label in the report header (no footer), the label is 0.2 height;
the report header is 0.2 height and set to can grow-yes, can shrink-no
2) a text box with a control source set up to concatenate 3-5 fields using
the trim, & and + operators (e.g., =Trim([MedName]+" " & [MedAmt]+" " &
[MedUnit]+" " & [MedRoute]+" " & [MedFreq]+" " & [MedReason]). The textbox
(height 0.2) is set to can grow-yes, can shrink-no; the detail (height 0.2)
is set to can grow-yes, can shrink-no;
It works Ok with the subreports expanding/collapsing if each subreport has 1
or more lines; however if the subreport is blank/empty my main report will
have a blank space there with multiple blank lines.
I have stacked each subreport so that there really is no space between them.
The subreports are linked to the "main" report with the parent/child linkage.
Should I be using the IIf Null process instead of the Trim/+ route?


Make sure the main report has each subreport control's and
their section's CanShrink property set to Yes.
 
D

dlazenby

That did it. Thanks very much Marshall.

Marshall Barton said:
dlazenby said:
I am creating a report (for a medical database) that has multiple,
consecutive subreports in it. (BTW, it is also set up-using a command button
on the form, to print a single patient record at a time).
Each subreport's structure is somewhat similar: It is a report that consists
of:
1) a simple label in the report header (no footer), the label is 0.2 height;
the report header is 0.2 height and set to can grow-yes, can shrink-no
2) a text box with a control source set up to concatenate 3-5 fields using
the trim, & and + operators (e.g., =Trim([MedName]+" " & [MedAmt]+" " &
[MedUnit]+" " & [MedRoute]+" " & [MedFreq]+" " & [MedReason]). The textbox
(height 0.2) is set to can grow-yes, can shrink-no; the detail (height 0.2)
is set to can grow-yes, can shrink-no;
It works Ok with the subreports expanding/collapsing if each subreport has 1
or more lines; however if the subreport is blank/empty my main report will
have a blank space there with multiple blank lines.
I have stacked each subreport so that there really is no space between them.
The subreports are linked to the "main" report with the parent/child linkage.
Should I be using the IIf Null process instead of the Trim/+ route?


Make sure the main report has each subreport control's and
their section's CanShrink property set to Yes.
 

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