Re: Creating Database Reports with EOF
Re: Creating Database Reports with EOF
- Subject: Re: Creating Database Reports with EOF
- From: Petite Abeille <email@hidden>
- Date: Fri, 14 Mar 2008 20:35:43 +0100
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 way
than to get qualifiers for each month and create new
FetchSpecifications
for 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/
--
PA
http://alt.textdrive.com/nanoki/
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden