Crystal Reports timeout

[Former Member]

Our .NET1.1 and 2.0 remote apps host CrystalDecisions.Windows.Forms.CrystalReportViewer, which consume CR11 .NET Runtime Web Service. We can seccufully run the report over 800,000 records in MS SQL server with CR designer via ODBC. The default ODBC timeout setting is fine for the case.

But we got an error message with the .net remote apps while consuming the CR web servcie in 2 minutes of execution, "The operation has timed-out".

I added the following in the web.config

<httpRuntime executionTimeout="600" />

The error message still occurs.

Is there also a timeout on the client side (in this case my .net remote app is the client

of the CR web service)?

Many thanks!

[former_member183750 · Accepted solution]

What kind of web service is it? A serverfilereport web service or a report web service (report published as a web service) or a custom web service?

The default timeout of a webservice is 100 seconds, I think.

For a report web service, the service has a timeout property to set the client timeout in milliseconds.

Ludek

[Former Member · Accepted solution]

It is the ServerFileReportService,

<%@ WebService language="C#" class="CrystalDecisions.Web.Services.ServerFileReportService" %>

I found the Web Request Tiemout setting for EnterpriseReportService, but not ServerFileReportService,

<%@ WebService language="C#" class="CrystalDecisions.Web.Services.CustomEnterpriseReportService" %>

namespace CrystalDecisions.Web.Services

{

using System;

using System.Web.Services;

using CrystalDecisions.Shared;

using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.ReportSource;

using CrystalDecisions.Web.Services;

using CrystalDecisions.Web.Services.Enterprise;

[ WebService( Namespace="http://crystaldecisions.com/reportwebservice/9.1/" ) ]

public class CustomEnterpriseReportService : CrystalDecisions.Web.Services.Enterprise.EnterpriseReportService

{

public CustomEnterpriseReportService()

{

// This timeout is the time in milliseconds that we will wait for a

// response from the Web Component Server. The default is 90000 (90s).

// WCSClient.WebRequestTimeout = 120000;

}

}

}

[former_member183750 · Accepted solution]

Here is the code you'd need to use:

protected void Page_Load(object sender, EventArgs e)

{

ServerFileReport sfr = new ServerFileReport();

sfr.WebServiceUrl = "http://localhost/CrystalReportViewers115/ServerFileReportService.asmx";

sfr.ReportPath = "chart.rpt";

sfr.ObjectType = EnumServerFileType.REPORT;

//

newServerFileReport longRPT = new newServerFileReport(sfr);

CrystalReportViewer1.ReportSource = longRPT;

}

public class newServerFileReport : CrystalDecisions.ReportSource.RemoteReportSource

{

public newServerFileReport(ServerFileReport report)

: base(report, false)

{

m_proxy.Timeout = 600000;

report.GetExtraData();

report.ObjectType = EnumServerFileType.REPORT;

report.ToUri();

}

}

Ludek

[Former Member · Accepted solution]

Many thanks, Ludek, for the best support I got.

Your method works with our WinForm remote apps on CR 11 .NET Runtime Release 2!

We will also test your method for the following case with https.

Some customers have the report source pointing to web service behind proxy server,

Smart Client -

---

https---> ISA (proxy) -

---

http----> App server

We attached network credentials to remote report source object, which is specified in http://msdn.microsoft.com/en-us/library/ms227492.aspx .

Is this case also supported by your method?

We may also want to use your method for early apps on CR 9/10 .NET Runtime if supported.

[former_member183750 · Accepted solution]

Yes, it should work, no extra work needed. Only thing to keep in mind is that CR XI r1 (assemblies version 11.0.3300.0) can only be used with the 1.x. framework. To use CR with framework 2.x you need to use CR XI r2 (assemblies of version 11.5.3700). More info on all of the CR and .NET versions is in [this|https://wiki.sdn.sap.com/wiki/display/BOBJ/CrystalReportsassemblyversionsandVisualStudio+.NET] wiki.

Ludek

[Former Member]

Thanks;)

I will definitely recomend your forum to our dev, support, and customers.