PHP/MySQL Reports to Printer

Problem is this:

- Apache/PHP/MySQL installed;
- Huge database in MySQL
- two tables in the database, first, main table is huge - and second table is small, just linked as foreign;

Using MySQL and PHP (PHP has some printer functions) - how to:
Make reports for printer output (MS Access like), with headers and footers (like in MS Access, but for MySQL), record numbers, with possibility to print "from-a-record to-a-record" (user can put both, from and to numbers into the form), user also can choose fields - he/she wants to print. User can see page example at browser, but not complete report (database is huge). Printer output should be system (windows) default printer.

Is there (already) a PHP (/MySQL) script capable to do this task?

Anybody had something like this to solve yet?

Thanks for any answer!

I would avoid using the php printer functions becaues they are only available in Windows systems. Actually, I notice the manual says '...only available under Windows 9.x, ME, NT4 and 2000'. Anyone know if they work in XP?

I've been using the FPDF class www.fpdf.org to handle report generation in php. It generates a PDF file which the user can then save locally or print.

Doing the layout is a bit of a pain, but the quality and control you get is worth it to me.