Crystal Reports choks with large amount of data

[abcddcba]

We've been struggling to get a solution to this problem for a long time now so any help would be grately appreciated. Here is the problem...Our ASP.Net web application generates reports created using Crystal Reports 8.0. All the reports work fine if they have less amount of data and show up in the browser in both PDF and Word format,but choks when amount of data grows. Say a report works if it bring 20 pages of data but falls apart when its 100 pages or so. These reports work fine when run with Crystal Reports 8.0. Back end database is MS SQL Server. Here is error I get:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Stack Trace:

[InternalException: Failed to open a rowset.]
.K(String 
, EngineExceptionErrorID )
.F(Int16 , Int32 )
.E(Int16 
)
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
CMS.cCrystalReportsProcessing.Processreport(XmlDocument oXMl, XmlDocument oXMLField, String sSelFormula, Boolean bUseDatabase, Boolean bRptFieldUsed, HttpServerUtility oServer, HttpRequest oRequest, HttpResponse oResponse, cErrorLog oErrorLog) in C:\Inetpub\

http://wwwroot\cms\cCrystalReportsProcessing.vb:486

CMS.CrystalReportsProcessing.Page_Load(Object sender, EventArgs e) in C:\Inetpub\

http://wwwroot\cms\CrystalReportsProcessing.aspx.vb:119

System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +724

 

[dgillz]

I am not sure this is a crystal reports issue. The largest database I ever had in a report was 8.5 million records, and it worked no problem - just took a little while. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[abcddcba]

These same reports works fine when generate from a VB application using Crytal Reports Engine. In ASP.Net most of these choks if returned with large amount of data. I'm just confused if its a Crystal Reports problem or .Net issue. Is there any setting which determines the amount of data crystal report can handle or something?

 

[Naith]

Sounds like you probably have a maximum number of records limit which is set in your web application. Exceeding the limit returns an error.

Like Crystal Enterprise's -maxDBResultRecords. If you set this to 0 in the page server command line it allows unlimited records.

Naith

 

[abcddcba]

Under the Page Sever tab I've checked the setting for Maximum thread and its already set to Unlimited. Since I'm using CR 8.0 so I don't see any maxDBResultRecords setting.
Any other suggestion which I can try. Thanks.

 

[abcddcba]

any more input guys?? i'm waiting...

 

[lyanch]

This may be a .Net issue. HAve you contacted Seagate?

 

[Ngolem]

this is most certainly a .net issue....check out their Knowledgebase to see if you can find a solution....but don't be surprised if you find the issue but not solution shown....rather it is just tagged as an issue.

Frankly I wouldn't be excited about using Crystal in a .NET environment...many issues need resolving from the look at the list of growing problems in the Crystal KB Jim Broadbent