«

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

stig wrote:

> 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.



--
Brian Wakem

stig wrote:

> 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/Clas...ML-0.9/HTML.pm
( http://search.cpan.org/search?query=DBI+HTML&mode=all )

--
John Small Perl scripts: http://johnbokma.com/perl/
Perl programmer available: http://castleamber.com/
Happy Customers: http://castleamber.com/testimonials.html