Crystal report with sub report not running on Crystal Enterprise

[scott1971]

I have a Crystal report that looks at a high level of claims and a sub report linked to it that is used to drill down to claim number.  In crystal reports the report runs quickly (two minutes) and the drill down works fine.  When I publish the report to enterprise the report take hours to run (I have canceled it after a few hours).  The report seems to be trying to run every possible combination of the sub report when run on enterprise. Does anyone know if you can publish reports like this?  

 

[MJRBIM]

Which version of Crystal ?
Which version of Enterprise ?
What kind of database ?
What method of connectivity (eg. ODBC, Oracle Native) ?

Are you using CUSTOM database connections when you post the RPT to Enterprise?

There was a known-bug with CUSTOM database connections and sub-reports.

The fix was to update the ORIGINAL database connections in the RPT file.

 

[scott1971]

Reports Version 11.0.0.895
Enterprise Version 11.0
SQL Server 2005 Database
ODBC connection
Not using Custom
"Use original database logon information from the report"

I have published and run various reports with sub reports but have never linked a summary to a detail table using sub reports and run it on enterprise. I have monitored it with "dbcc inputbuffer" in SQL Server and it seems to be searching every concievable combination of the drill down whither it is in the where clause or not. This does not happen when I run it on crystal reports as it seems to only run the sub report when you drill down.

 

[cjlarue]

are you linking the sub and main report on the id field of the record you are dirlling on? sounds like a linking issue.