To pre-set the printer orientation,header,footer,margins and format, download the free script-x activex.
http://www.meadroid.com/scriptx/
With this activex, your user will be able to print the report correctly from the browser.

Place the report inside a fixed width table to avoid right-side lost of data in the printed version.
(For A4, it might be somewhere around 700 pixels width, do some tests)

HTH :-)

>Hi,
>I've got a sql application that I want to run reports off via the web. The parameters for the reports are entered via a web form and when that is submitted it calls a stored procedure that returns the results as a huge string of HTML.
>
>Back at the client end I want the returned html to be formatted so that each record I am returning fits on a page of A4. Does anyone know of an easy way to do this? Can I automatically open up Word and feed it the html?
>
>Phil.