Database reporting tools?

[Derek Hohls <DH...@csir.co.za>]

I was wondering whether or not anyone had experience with web-based
database reporting tools - preferably ones that have been integrated
into
a Cocoon app.  The tools does not have to be open source, though this 
would be a first choice.

The report tool should - ideally! - be able to:
* allow admin-created reports via SQL definitions (XML would be good)
* allow for a wide range of SQL (including all JOIN types)
* allow for extraction of data in multiple formats (must include
eXcel)
* run reasonable quickly
and, obviously, have a customizable web-based front-end that allows
end-users to resort results and/or dynamically create subsets of data 
through data ranges and field specifications.

I know about - and have tried out - xReporter - but have been unable
to
get it working on a Unix box (long story, don't ask); and, on the one
Windows machine where is did install, the memory and time demands 
for doing data extracts with more than 50k records were just too steep
or not feasible.

Any help/opinions welcome!

Thanks
Derek

PS I know there are lots of tools out there... I am looking for
feedback
on ones that people have actually used n real-life applications, not
ones 
that just  look as though *could* do the job.

PPS Yes, in a worst case I could use Cocoon... and have done that in
the
past... but I am looking for a 'quick-and-easy' user-driven approach
that
I can just "install and use", and trying to not reinvent any wheels!


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: Database reporting tools?

[Brian Burridge <bb...@gmail.com>]

I just began a reporting project last month, and am using Jasper and
Open Reports. I wrote a brief summary of the advantages of those on my
blog: http://blog.hirebrianburridge.com/2005/04/08/jasper-and-open-reports/.

Hope that helps,
Brian

On Apr 7, 2005 8:42 AM, Gerald Aichholzer <ga...@iicm.tu-graz.ac.at> wrote:
> Derek Hohls wrote:
> > I was wondering whether or not anyone had experience with web-based
> > database reporting tools - preferably ones that have been integrated
> > into
> > a Cocoon app.  The tools does not have to be open source, though this
> > would be a first choice.
> >
> 
> Have a look at http://www.sourceforge.net - there are many web
> based reporting tools available.
> 
> I have had a brief look at such tools about four months ago,
> but the project has been cancelled by the customer, so I have
> stopped my investigations.
> 
> AFAIR I have shortlisted OpenReports (Jasper based) and a
> product DataDivsion. Other projectes I can remember are
> iReport, JFreeReport and RLIB-report.
> 
> Not much help, but maybe some tipps for further research :)
> 
> Gerald
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: Database reporting tools?

[Gerald Aichholzer <ga...@iicm.tu-graz.ac.at>]

Derek Hohls wrote:
> I was wondering whether or not anyone had experience with web-based
> database reporting tools - preferably ones that have been integrated
> into
> a Cocoon app.  The tools does not have to be open source, though this 
> would be a first choice.
>

Have a look at http://www.sourceforge.net - there are many web
based reporting tools available.

I have had a brief look at such tools about four months ago,
but the project has been cancelled by the customer, so I have
stopped my investigations.

AFAIR I have shortlisted OpenReports (Jasper based) and a
product DataDivsion. Other projectes I can remember are
iReport, JFreeReport and RLIB-report.

Not much help, but maybe some tipps for further research :)

Gerald

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org