Creating Printable, Multi-paged Reports from SQL Query
Posted: Thu Oct 20, 2005 11:57 am
Hi!
I'm generating several "report" pages with a combination of SQL queries that result in pages of varying length depending on the SQL output. My client needs these pages to be printable and has requested that I figure out how to create "page breaks" when printed. I have to display header/footer info for each "page" and they'd like page numbering as well. I've just started messing with PDF generation, and while this seems like the way to go, its very tedious, especially when dealing with dynamic data (as from a db query). Anyone have any ideas for "paging" html output with PHP other than through PDF generation? Any help is GREATLY appreciated!
I'm generating several "report" pages with a combination of SQL queries that result in pages of varying length depending on the SQL output. My client needs these pages to be printable and has requested that I figure out how to create "page breaks" when printed. I have to display header/footer info for each "page" and they'd like page numbering as well. I've just started messing with PDF generation, and while this seems like the way to go, its very tedious, especially when dealing with dynamic data (as from a db query). Anyone have any ideas for "paging" html output with PHP other than through PDF generation? Any help is GREATLY appreciated!