To elaborate a bit on Nuno's comments - I believe that the option that you are looking for is called 'perform grouping on server' - which is a little misleadingly named as IIRC it generates ad-hoc sql and sends it to the db for the RDBMS to run the SQL It should really be called 'use the database' or something similar. It doesn't get to the level that your typical DBA would like - control over the sql - but it does enable your database server to fall to its knees instead of the client PC. Er perhaps that should read slightly differently :). This option is not available if your user has written the sql statement themselves - but I've never seen a case of this actually happening - people get crystal because they want to query a database but don't know how to query a database (SQL).
I'd entirely agree with the suggestion that you get involved with the manager to try and determine what he is attempting to achieve - an alternative approach would be to dump the data to flat files and give them to him 'for performance reasons' crystal will happily talk to flat files. This latter suggestion may not be the wisest political move in your organisation :0
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon May 10 2004 - 03:10:30 CDT
