SAP Knowledge Base Article - Public

1216442 - Data is not refreshed when report is run in .NET and published as a Web Service

Symptom

An application uses Crystal Reports for Visual Studio .NET as the reporting development tool. The application publishes the report as a Web Report Service or as a Server File Report Web Service.

When the report is run using the same parameter values, the data that is returned is not refreshed.

Why is the data not refreshed?

Resolution

The data is not refreshed because by default the report is cached on the server for two hours and ten minutes. During this time period if the report is run, but the parameters have not changed, the report uses the cached data rather than refreshing the data.

There is no workaround for this behavior when publishing a report as a Server File Report Web Service.

However, when publishing a report as a Web Report Service, you can set the default timeout value. By setting the timeout value to two seconds, the data is refreshed every two seconds even if the parameters are the same.

For example, to set the timeout value to two seconds, add the following code to the CreateReport function:

CachedReportConstants.DEFAULT_TIMEOUT = New TimeSpan(0, 0, 2)

Keywords

WEBREPORTSERVICE SERVERFILEREPORT DOTNET VB.NET VS.NET CACHING CACHE REFRESH Crystal Reports for Visual Studio Web Services Parameters , c2014162 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports, version for Visual Studio .NET 2005 ; SAP Crystal Reports, version for Visual Studio .NET 2008 ; SAP Crystal Reports, version for Visual Studio .NET 9.1