by njw » Tue Feb 13, 2007 12:23 pm
I was considering:
a form to be populated via an ini file, perhaps, with fields from a table. The form would offer for each field, whether to include it in the report and options to filter records - perhaps offer EQ, NE, LT, GT, BETWEEN a and b. Options to define a sort order and grouping would be good. Ability to create a Header description and/or footer would also be nice.
then a script to create the SQL code, run the select statement and produce a simple report, offering, say, HTML on screen and PDF or rtf to be downloaded.
Nothing complicated on layouts: html table format would be fine.
I don't think it's particularly difficult, and I developed something similar many years ago on a Vax, but my PHP is nowhere near the level that would be needed!!!
The reports I need now are really just dumps of text data, but I can't put them into Excel because one of thefields blows the cell limits.
I;ve done a fair bit of googling, but there doesn't seem to be anything out there.