Advance reporting layer over mysql Database

[simpli]

Hi,

I am going to build an application with php and mysql. In the end result, there are going to be a few tables with all sorts of data. I would like to build all the possible my customers would need and have them available with one tool or other in Ajax. I however know that it would be impossible for me to anticipate all my clients reporting needs. I was first thinking of building an "Advanced Reporting Module" in my application (like business objects) where they can create their own reporting in an Ajax environment with the matching responsiveness. Before embarking on something as ambitious as that however, I was wondering if anyone know a product (commercial or otherwise) that gives this kind of service. I would add that module on top of my database and this would give the users the access to the underlying data for reporting purposes.

 

Thanks for sharing anything you think can help.

JR

[Ken2k7]

What kind of data is this so called module supposed to report?

[simpli]

It would possibly all the information that is in the databases of the system, except maybe for the systems database. So all the user information they will possibly put in, if they want to build a report counting the number of people they have in their organization or the number of people in a certain category working at this location or whatever. Because they could want to pull all kind of information, it's almost impossible to create one report to rule them all therefore my need.

JR