I have a chart of accounts with departments across the top.

The accounts down the side are grouped into categorys.

If Level 1 grouping is selected I would like the sheet to print in Landscape
(fit to 1 page), but if Level 2 grouping (more detailed) is selected I would
like the sheet to print in Portrait (fit to 1 page).

Can it be done ?!?