Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Caching issue

This thread is forked from here: Please Help With Strange Cache Issue

We are experiencing the same issue. It persists between SQL Server 2005 and IIS 6 restarts. Here is the expected chain of events:

1) User submits a value in a form

2) Database table is updated with an "LTSel" column value of true or false based on the user's submission criteria

3) Database is queried for rows which are true

4) Page generated for rows which were true, and presented to user

Steps 1 and 2 work fine. We've verified that the database LTSel column is updated based on the form submission. The problem is that somewhere between steps 3 and 4, the information does not churn into the next report, and the user is presented with the previous report for a minute or more.

Answers to Ludek's questions in the original thread:

What version of CR? Crystal Reports for Visual Studio 2005

What version of .NET? 2005

What updates for CR have been applied? None that I know of

What OS? Windows Server 2003

Make sure "Saved data" with report is not enabled. No option

Make sure you dispose and close the report object. Unknown

Former Member
Not what you were looking for? View more on this topic or Ask a question