+ Post New Thread
Results 1 to 3 of 3
General Chat Thread, Report Design for MySql Data in General; We currently write our school reports using a simple web front end and MySql database, this data is collected centrally ...
  1. #1

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    30

    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!

    Thanks!

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,601
    Thank Post
    110
    Thanked 771 Times in 599 Posts
    Rep Power
    183
    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.

  3. #3

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    30
    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.



SHARE:
+ Post New Thread

Similar Threads

  1. New 2D Design talking to the Old Mill Design
    By Sean in forum Educational Software
    Replies: 5
    Last Post: 15th January 2008, 10:26 AM
  2. back up and restore mysql data (joomla-ravenswood)
    By Uraken in forum Web Development
    Replies: 4
    Last Post: 28th November 2007, 11:35 PM
  3. Update Active Directory with mySQL table data?
    By netadmin in forum Windows
    Replies: 8
    Last Post: 30th October 2007, 11:43 PM
  4. Replies: 1
    Last Post: 25th September 2007, 08:34 PM
  5. Php/MySQL Web Design
    By Adam in forum How do you do....it?
    Replies: 8
    Last Post: 18th July 2005, 05:13 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •