For Programmers: Free Programming Magazines  


Home > Archive > PERL Miscellaneous > June 2005 > report generator









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author report generator
stig

2005-06-09, 8:57 am

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

2005-06-09, 3:58 pm

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

John Bokma

2005-06-09, 3:58 pm

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/Cla...TML-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

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2009 codecomments.com