Help generating printable PDF web reports

Web Server Environment:

1) Apache 2.2.14

2) Ubuntu 10.04 2.6.32-24

3) MySQL 5.1.41-3

I am running Dreamweaver CS5 (CS5 Master Collection) on XP Pro.

need help figuring out how to design PDF reports.  Our MySQL database contains student data that I need to create a 1 page PDF document for each student.  I have successfully wrote the code to produce a web page report that contains a section of information for each student but the result is one VERY long web page.  I would like to include a button on that page that once clicked would automatically create 1 PDF document that contains many pages that consists of 1 report page for each student.  It would also be nice if, once that report is created, a print dialog box would display allowing the user to select which printer they want to send the document to.  Is there a way to create a PDF report template that can be used to accomplish this?  I am hoping that Dreamweaver might have some functionality that could help.

I can't tell you how many hours I have already put into  researching/googling for a solution to my requirement but all with no  success.  The closest thing I have come to a solution is utilizing  LiveDocx but since the student information is sensitive and since the LiveDocx solution requires the information being sent to there server before the PDF document is produced, Administration  has said no to that option.  Even if they said yes, I was only able to  figure out how to create one document per student thus leaving the  daughting task of having to open up each document individually and then sending it to the  printer.  I am totally at my wits' end!!!  Any help will be greatly appreciated...plus, it will allow me to stop ignoring my other classes let alone my family relationships.  Are you feeling like you are guilted into helping yet?