<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
<BR><BR>> Date: Mon, 28 Apr 2008 15:47:24 +0100<BR>> From: david@codepoets.co.uk<BR>> To: phpwm@mailman.lug.org.uk<BR>> Subject: Re: [Phpwm] SQL query builder<BR>> <BR>> -----BEGIN PGP SIGNED MESSAGE-----<BR>> Hash: SHA1<BR>> <BR>> alan dunn wrote:<BR>> | The dataset is quite big - about ten tables of dynamic data and<BR>> | 30/fields per table so pre-defining queries would be challenging.<BR>> | We are looking at phpPgAdmin - but before letting the users in there we<BR>> | would have to disable all the update/delete/drop functionality - it is<BR>> | too comprehensive. Crystal Reports is almost a model for what we want -<BR>> | but without all the report formatting - maybe I just tell the client to<BR>> | buy copies of Crystal Reports!<BR>> |<BR>> <BR>> <BR>> Ah; in that case you probably want to use iReports - the only problem<BR>> with it is that you need to be able to write SQL (or at least have<BR>> written the queries beforehand for them to use [this was the case last<BR>> time I looked at it])<BR>> <BR>> thanks<BR>> David.<BR>> <BR>> http://www.jasperforge.org/jaspersoft/opensource/business_intelligence/ireport/<BR>> <BR>> - --<BR>> David Goodwin<BR>> <BR>> [ david at codepoets dot co dot uk ]<BR>> [ http://www.codepoets.co.uk ]<BR>> -----BEGIN PGP SIGNATURE-----<BR>> Version: GnuPG v1.4.6 (GNU/Linux)<BR>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org<BR>> <BR>> iD8DBQFIFeN8/ISo3RF5V6YRAvk3AKDBNwWvRq5j/KdbXQntYPIxzmPyowCgnjX4<BR>> GuHTXnaHoqI8aosUdufmIF0=<BR>> =kTes<BR>> -----END PGP SIGNATURE-----<BR>> <BR>> _______________________________________________<BR>> Phpwm mailing list<BR>> Phpwm@mailman.lug.org.uk<BR>> <A href="https://mailman.lug.org.uk/mailman/listinfo/phpwm">https://mailman.lug.org.uk/mailman/listinfo/phpwm</A><BR><BR>
Yep, jasper's good. I've also used BIRT on eclipse but it's a little clunky. You may also want to invest a little time in looking at Pentaho<BR>
<BR>
I was looking for a business objects alternative a while back. We ended up bulding the universe through iReports which worked fine on a DB consisting of over 200 tables (can't remember the size of it though). Although, if I remeber correctly, we had to manually build the universe rather than the client connect directly to it. That's surely got to be possible...<BR>
<BR>
Keep us posted!<BR>
<BR>
Sukh<BR>
<BR><br /><hr />Get fish-slapping on Messenger <a href='http://mobile.uk.msn.com/pc/messenger.aspx ' target='_new'>Play Now</a></body>
</html>