Report printing problem

[Anauz]

Hi

I have a report which is populated from several queries. The report is constructed off a main report with 3 subreports inside it. The problem is that in some cases one of the subreports is empty...and when i print, it prints out blank pages. Is there a way i can prevent access from printing blank reports?

 

[Rich]

Have you set the CanShrink/Grow properties to yes?

 

[Anauz]

no i haven't. Will this prevent it from printing blank pages if one of the subreports has no data?

 

[David R]

You also can consider setting the Can Shrink/Can Grow properties of the entire Detail section, if the above by itself doesn't work.

HTH,
David R