Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Perl Misc (http://www.velocityreviews.com/forums/f67-perl-misc.html)
-   -   report generator (http://www.velocityreviews.com/forums/t892770-report-generator.html)

stig 06-09-2005 08:17 AM

report generator
 
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 06-09-2005 03:57 PM

Re: report generator
 
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 06-09-2005 03:59 PM

Re: report generator
 
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



All times are GMT. The time now is 03:11 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.