Group header section probblems on report

[EddyLLC]

I have a group header section on a report that contains one field. Sometimes this data field is null yet when I print a report there is a empty space still is set on the report. Is there a way to move the section below up on the page if the one data field is null? If there is nothing to print in section 1, section 2 moves up on the page and is printed where section 1 would have been. Maybe some sort of cancel event?
Thanks

 

[VicRauch]

Where the null data is happening, set the "CanShrink" property to True.

 

[EddyLLC]

Thanks, that worked. Now let me ask this, the report data is provided by a query. Each record in the query is a separate line in the report. Is there a setting that I can adjust the width of space between lines on the report. It seems between every new record in the query, line in the report, there is about a half inch of empty space. I have the sections of the report set to can shrink if no data is there yet between records it seems to automatically space some.

Thanks

 

[VicRauch]

The height of the section itself where you have placed the fields to print. The section itself can be made shorter by either draging the bottom line up, or within the properties of the section, by changing the Height property to a smaller number.