Skip to Content
0
Former Member
Feb 20, 2011 at 12:44 AM

manging crystal server cashing

26 Views

We are using crystal server 2008 in a big project last week i faced a problem as below.

we have a screen which contains two buttons the first update a field in the DB and the other one fire a report to be displayed in PDF format.

this report is displaying the modified field. but when i generate the report i found that the report is getting the last value for the modified field not the new one.

i opened the report from crystal designer and i previewed the report and i found that the report is getting the right value but when i ask the crystal report server to preview the report it gets me the old value.

the report is designed using the wizard and i tried also redesign the report using the command tool but the same problem remains.

I have a theory which I need any one to verify it to be tru or false.

the crystal server cashed the result after the first running from this report and when any user is asking the server for the same report with the same parameters it searches first inside the cash if found retrieve the data else send the query to the DB.

if I am right I need to know how to make the crystal server refresh the data for this specific report each time the user is asking the server for?

If no then tell me what to do plz