[Phpwm] SQL query builder

[sukh virdee]

> Date: Mon, 28 Apr 2008 15:47:24 +0100> From: david at codepoets.co.uk> To: phpwm at mailman.lug.org.uk> Subject: Re: [Phpwm] SQL query builder> > -----BEGIN PGP SIGNED MESSAGE-----> Hash: SHA1> > alan dunn wrote:> | The dataset is quite big - about ten tables of dynamic data and> | 30/fields per table so pre-defining queries would be challenging.> | We are looking at phpPgAdmin - but before letting the users in there we> | would have to disable all the update/delete/drop functionality - it is> | too comprehensive. Crystal Reports is almost a model for what we want -> | but without all the report formatting - maybe I just tell the client to> | buy copies of Crystal Reports!> |> > > Ah; in that case you probably want to use iReports - the only problem> with it is that you need to be able to write SQL (or at least have> written the queries beforehand for them to use [this was the case last> time I looked at it])> > thanks> David.> > http://www.jasperforge.org/jaspersoft/opensource/business_intelligence/ireport/> > - --> David Goodwin> > [ david at codepoets dot co dot uk ]> [ http://www.codepoets.co.uk ]> -----BEGIN PGP SIGNATURE-----> Version: GnuPG v1.4.6 (GNU/Linux)> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org> > iD8DBQFIFeN8/ISo3RF5V6YRAvk3AKDBNwWvRq5j/KdbXQntYPIxzmPyowCgnjX4> GuHTXnaHoqI8aosUdufmIF0=> =kTes> -----END PGP SIGNATURE-----> > _______________________________________________> Phpwm mailing list> Phpwm at mailman.lug.org.uk> https://mailman.lug.org.uk/mailman/listinfo/phpwm
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
 
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...
 
Keep us posted!
 
Sukh
 
_________________________________________________________________
Bag extra points with the Walkers Brit Trip Game 
http://www.walkersbrittrips.co.uk/game
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.lug.org.uk/pipermail/phpwm/attachments/20080428/3cf423fe/attachment.html