Hi Happy YN,
I just come accross this thread today. Some time ago i had posted a sample db here:
It's a dynamic report but there are still some limitations. Is it possible that you could use VB codes to conditionally alter the print orientation and number of colomns when required?