Re: Grouping/aggregating data in Crystal Reports

I wonder why "Perform Grouping On Server" is *NOT* the default ? Is it based on the "understanding" that programmers prefer grouping on the client
because the clients can do the job faster than the DB server OR DB servers in development environments are much slower than in production so development is done with this option set for the client OR that some databases do not allow
GROUP BYs on the DB Server ?

At 06:55 AM Friday, Allen, Brandon wrote:
>List,
>
>I just learned something very interesting about Crystal Reports that
>I thought I'd share with the list. By default, when a Crystal
>report is designed to do an aggregate operation, for example group
>by customer and sum the total sales, Crystal will query ALL the data
>from the database, and then perform the aggregation on the client side.
>
><http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=E50260AE571FFE68CB5EAD35AA95E8B7?cmd=displayKC&docType=kc&externalId=c2009635&sliceId=&dialogID=1554409&stateId=1%200%201558047>http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=E50260AE571FFE68CB5EAD35AA95E8B7?cmd=displayKC&docType=kc&externalId=c2009635&sliceId=&dialogID=1554409&stateId=1%200%201558047
>
>In the case I encountered today, this simple change was the
>difference between the report failing after 12 hours, and completing
>successfully in 8 minutes.
>
>Regards,
>Brandon
>

Hemant K Chitale
http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l