Timeout When Reporting on Many Fields Via Oracle View

[ihda]

I'm producing a Crystal report (8.5) (on a Win2000 platform) using an Oracle 9i view. The view selects data from 13 tables and contains 40 fields. If I select a small number of fields for the Crystal report, the report executes fine. If I select all or most of the fields, Crystal hangs. (A review of the task list displays 'not responding'). Is there a registry entry I need to update?

Thank you.

 

[synapsevampire]

What connectivity are you using, this is critical when hitting an Oracle database.

If you're using the Oracle supplied ODBC driver as opposed to the CR supplied one, you'll have some problems. It's best to try the Oracle Native connectivity.

Keep in mind that there are lots of data types that didn't exist in Oracle when CR 8.5 was released, so you may have problems that will require a View to CAST objects, or even be forced to use a Stored Procedure.

-k