PHP/Postgresql Report Generation

[roscoecline]

div style="text-align: justify;"span style="font-family: times new roman;"I am considering a number of alternatives to deliverying reports in a PHPostgresql/Linux environment. These include:/spanbr style="font-family: times new roman;"
pre style="font-family: times new roman;"1. Subscription. That is, users enter which reports, frequency, destination (i.e., email address), etc. The system runs brjobs as stored procedures/scheduled events to generate and distribute. br br2. Library. That is the project customer defines report parameters. We deliver to a project library and users can pull bras needed. br br3. Real-Time/On-Demand. Users go online, enter parameters, and generate reports in real time. Reports are brrendered in HTML or PDF. The user would then be responsible for downloading/printing. br brThere are a number of technical, business, and policy issues around each alternative. It is likely alternative #1 will bebrused. Would like some perspective on possible system tools (in addition to PHP itself) to accomplish this work - bropen source preferred. Obviously, I will want something that is reliable, relatively straightfoward to integrate, and that brruns efficiently with the stated platform.brbrThanksbrbr/pre
/div
br