Page Header with Fit to 1 page wide
 

I've got a report I need to provide to a group of users that contains
a bunch of columns, but it's setup to print only 1 page across which
means that the print gets pretty small. I'd like to allow the users
to hide detail columns they don't wish to see so the print is larger -
the problem is that the page header that looked fine when all the
columns were included is now too big relative to the rest of the
report.

Does anyone know of a way to restrict the size of the header to the
space it has allocated to it in the margin settings? That's probably
a longshot, but as an alternative, is there a way to resize the header
when columns are hidden?

Thanks in advance,

Josh