eliminate blank lines /try to have a better look(reports)

[Urban Planning Major]

My report of my table is ugly. I need to know how to eliminate blank lines if
no data is available for that line. No conclusions of info on other pages.
Have all conclusions of data to start all over on a new page.

 

[Rick B]

One way to eliminate blank records is to exclude them from your record
source. In your query, only pull the records you want. If the records are
desirable, but some fields are blank, then you can try using the "can
shrink" property on the report controls to have the blank space eliminated.

To start new pages, you can use your sorting and grouping options to set a
group footer or header based on your grouping. You can then set the group
header or footer properties to start a new page before or after.

Please post back with more details if this is not helpful and perhaps we can
delve into it further.

 

[Urban Planning Major]

Rick, that worked perfect thanks for the answer the report has a better look.
Thanks again sir