Auto Hide Blank Rows without VB or Filtering

Given your conditions I don't believe you can.

Using Number Filter for > 0 would supress the blank rows but that's essentially the same as unchecking blank cells so I guess that isn't permitted either.

Plese try,

open ribbon Formula, choose Name manager , New
Type Area_to_print in the name box
Scope Report to print
Refers to : =OFFSET('Report to Print'!$A$1,1,0,COUNTA('UF Data (Contractor)'!$A:$A),7)

press OK

then select Print_Area and change refers to to:
Area_to_Print

Regards.

Sorry, I didn't noticed that you have a grand total at the bottom.
My solution didn't work.

Regards.

Note : But if you could modify formula and some of condition format
(and plus 1 to row high in offset formula) it might be work as if in the attatched file.

The attatched file was rough , might be need to modify some formula more.