|
|
Posted by NC on 11/03/05 18:36
Dave Smithz wrote:
>
> A client of mine wants to start generating some reports from their PHP /
> MYSQL database.
>
> They were previously gathering data from the screen and cutting and pasting
> it into a Word document template. They now just want to generate it.
>
> My initial thoughts are to just format the information in a table and then
> they print it out. But due to the dynamic nature of the reports and what is
> included, there might be issues with regard to the width fitting on a piece
> of paper, and the general format will not look as good as a Word document
> would.
>
> What ways could I approach this problem? Is there anything available which
> would make report formatting attractive and easy?
You can generate reports in either PDF or RTF.
The exact approach to generating PDF would depend on what PDF
generation tool(s) you use. There are at least two PDF generation
extensions bundled with PHP; there are also "pure PHP" tools such as
FPDF that are somewhat slower, but do not require any particular PHP
extension to be available (helpful for hosted applications).
If you want to use RTF (which is readable by most word processors)
instead, take a look here:
http://groups.google.com/group/alt.php/msg/fc914bd0d0a120fc
This is my old post to alt.php where I show how to build a simple
"report" (actually, a set of mailing labels) without having to learn a
lot about RTF.
Cheers,
NC
Navigation:
[Reply to this message]
|