Report Design for MySql Data

[danIT]

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!

 

Thanks!

[Ric_]

It is possible to attach to a MySQL database using OpenOffice Base which then provides all the Access-like features that people are used to - of course it's not web based.

[danIT]

Interesting, didnt know it could do that.

 

Ideally it needs to be web based and not reliant on installing new software. E.g. Software sits on the server and schools get a gui?

 

The design will be something that they will change yearly so once a template has been setup and saved then it unlikely to be changed often.