Joe, Fox Power Printer will let you change the paper size programmaticly for a report and it will format the report to the paper size.
Although, you probably should develop two different report layouts. One for 8.5x11 and one for A4.
You can get FPP at
www.foxprinter.comRob.