I am having a difficult time deciding how to create reports and push them to the users desktop. I am in the middle of developing a large browser based administration system, using PHP and Postgres. My only stumbling block is how to create and send invoices, purchase orders, shipping paperwork and various management reports to the users machine. I was going to use PDF format, but that looks labor intensive. The other option is to create the reports as an RTF file. Rich text is not much of an extension on simple text, so I wonder if anyone has considered this option? Browser printing an HTML based report doesn't seem to be viable, even with the page break control sytle sheets give.
I am sure that anyone building an actual application will this same requirement. All I have seen to date is the FreeMed project (from a report aspect), but I haven't had time to investigate their methods. Is there a template driven product anywhere? So far, this seems to be the only weak area for creating browser based business applications with PHP.
ALso, if there are any developers creating large scale business applications (i.e. not your usual interactive web sites) with PHP, I would like to hear from you. There may be an opportunity to share experience.
Thanks
Chris