Getting blank lines if no detail records

[ajarrell]

I am creating a report that is organized by project. The detail lines are to list payments applied to the project. How can I skip the detail section (or print a single blank line) if there are no payments in the separate payment table that match the project ID? Is there a way to tell that there were no matching payments and format accordingly? I currently get multiple blank lines.

Yes, I'm a novice. Thank you!

 

[EternalMyrtle]

Go into design view and open the report properties to the Format tab, and click on both the detail section and on the controls themselves and set them to "Can Shrink" it should make the blank lines disappear.

 

[ajarrell]

Worked perfectly. Thank you!