Report Design for MySql Data
We currently write our school reports using a simple web front end and MySql database, this data is collected centrally and printed using php templates and css.
We now have a number of schools in the local area wanting to use the software. To be honest I havent got the time to go and design reports for all of the schools and the other schools havent got any tech help to get it done.
So, im looking for an ActiveX (or Similar) control that will hook into the database and create the report design. Some of the schools want to create different report designs for each year group.
The tool ideally would let schools layout the report fields on screen, such as Effort, Attainment and Teacher Comment and then save that layout so any member of staff could save the report. Probably a bit like how M$ Access allows you to do.
Ideally in time this tool would mean that the report could be generated in any format, HTML (For on site printing) PDF (For school records and reporting to parents) or CSV/TXT (To allow the school to import to MIS when one is in place).
Hopefully a free bit of code or software is available as budget is tiny!