report generator

[stig]

hi.
are there any "good ways" or any modules that can be used to create report forms
in a simple manner.

from time to time users demand new reports to be created from data in a
database, the reports are presented in a web interface.

the problem is that every time the users need a new report, the developers need
to write a few lines of code and change a few templates.
if possible it would be good if the users could specify new reports themselfs or
at least if the developers could use some report genarator to speed up the process.

any ideas?

/stig

 

[Brian Wakem]

hi.
are there any "good ways" or any modules that can be used to create report
forms in a simple manner.

from time to time users demand new reports to be created from data in a
database, the reports are presented in a web interface.

the problem is that every time the users need a new report, the developers
need to write a few lines of code and change a few templates.
if possible it would be good if the users could specify new reports
themselfs or at least if the developers could use some report genarator to
speed up the process.

any ideas?

/stig

You could teach them basic SQL and give them read-only access to the
database.

or

Build an SQL query generating form like phpMyAdmin's 'select' function.

Without knowing what kind of data and what a 'report' is, it is difficult to
suggest anything specific.

 

[John Bokma]

hi.
are there any "good ways" or any modules that can be used to create
report forms in a simple manner.

from time to time users demand new reports to be created from data in
a database, the reports are presented in a web interface.

the problem is that every time the users need a new report, the
developers need to write a few lines of code and change a few
templates. if possible it would be good if the users could specify new
reports themselfs or at least if the developers could use some report
genarator to speed up the process.

So to boil it down, you look for a module that renders an SQL query as an
HTML table?

http://search.cpan.org/~aaronjj/Class-DBI-Plugin-HTML-0.9/HTML.pm
( http://search.cpan.org/search?query=DBI+HTML&mode=all )