How do I get rid of the blanks?

[Andy Dorph]

I have created a report which has hard coded "subheads" above subreports. In
the instances where there is data in the subreports, the report looks
perfect. In the cases where there is no data in the subreports, the portion
of the reports looks like the simulation below:

| Quarter 1
| |Yada yada yada |
|Quarter 2
========================= <--- denotes the blank area
|Quarter 3
| |Yakety Yak |
| |Yada yada yada |
Quarter 4
========================= <--- denotes the blank area
--------------------------------------------- <--- graphic line at bottom

Any suggestions, short of adding "dummy" records would be appreciated.

Thanks in advance

Any help

 

[Duane Hookom]

I suggest you tell us how you want the report/subreport to look? I think the
current display "says it all".

 

[Andy Dorph]

The report should look like this (note the absence of the denoted spaces).

| Quarter 1
| |Yada yada yada |
|Quarter 2
|Quarter 3
| |Yakety Yak |
| |Yada yada yada |
| Quarter 4
---------------------------------------------

Please note that when I enlarge the "subheaders," which have a shaded
background, to "cover" the subreports, the subreports overwrite the shading.

Thanks

 

[Duane Hookom]

Do you have the subreport control's Can Shrink property set to Yes?

 

[Andy Dorph]

I set the subreport to can shrink and it did not make a difference.

 

[Duane Hookom]

Did you set the section to can shrink?

 

[Andy Dorph]

Yes

Did you set the section to can shrink?

 

[Duane Hookom]

Write some code that cancels the printing of the section if the subreport
contains no records.

 

[Andy Dorph]

Which event do you suggest I use to trigger the code?

 

[Duane Hookom]

The On Format event of the section containing the subreport.