Greetings all!
I have a situation where, due to the database structure (mostly materialized views), the temp space that Oracle uses for the main SQL that Crystal generates grows to over 6gb when including the ORDER BY clause, but is only 60mb when it is removed.
I do have 2 Groups in the report (with Group 1 equal to the ORDER BY field).
Without creating a query-based data source, is there a way around this? (FWIW, I have all Sorting set to be done on the client side, at least what's available in the Options/Report Options).
Thanks!