On Mar 14, 2008, at 12:35 PM, Petite Abeille wrote:
On Mar 14, 2008, at 8:15 PM, Sennikov, Dimitri wrote:How would I be able to do that in WO with EOF? Is there an easier waythan to get qualifiers for each month and create new FetchSpecificationsfor each of the months? Wouldn't this method create too much overhead (ie 12 queries just for one report).Short answer: don't bother with EOF for reporting and let the database do the heavy lifting. You can always make the resulting data set available to EOF through your favorite database level representation such as views, store procedures, pipelined functions or such.EOF is meant to shield you away from SQL, in the same way as WOF shield you from HTTP.But for any non-trivial DMLs, you most likely want to use SQL directly.One way or another, once you have your data, something like Jeff Martin's ReportMill might be useful:http://www.reportmill.com/
I use openreports personally. Reportmill is better if you need to access your businesslogic inside the report, but if you just want to turn SQL into a table, openreports is easier.
http://oreports.com/ Pierce
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
