You can add VBA code to the Format (not Print) event of the appropriate
report section. For a record, that would probably be Detail_Format.
You can set individual controls Visible or not per some conditional. If
CanShrink is True and the layout is set correctly, you can "skip" a record
with no empty whitespace line if all the controls on that line are invisible
and allowed to shrink. Just be sure that your conditional sets Visible to
True as well as False, or you'll be hiding more than you intended.
Pretty sure you can also could also set the entire Detail section invisible
for specific records via code. Foggy memory.
You could also apply a filter to the report recordset during Report_Open to
exclude certain records.
*Usually* the best approach is that suggested elsewhere in this thread: Have
your query include only the records you want to print.
However, 'usually' is not the same as 'always' and there are alternative
approaches.
HTH,