cancel
Showing results for 
Search instead for 
Did you mean: 

Caching issue

Former Member
0 Kudos

This thread is forked from here:

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

There may be a couple of options for you:

crystalReportViewer1.ReuseParameterValuesOnRefresh = true;

crystalReportViewer1.RefreshReport();

Try the above to force the report engine to update the report info.

Thank you

Don

Former Member
0 Kudos

Sorry Don, I'm just the IT guy...where would these options go?

0 Kudos

In code of your application.

You'll have to get your developer to have a look at the problem.

Thank you

Don

Former Member
0 Kudos

Don,

The developer put that code in the application and said it had no effect on the problem.

Answers (1)

Answers (1)

0 Kudos

Form will show nothing until the viewer has a report to show. Seems to be a lg in loading the report into the veiwer. No way to speed this up that I know of.