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

Other related posts: