crystal reports selection criteria

the first report that I set the .selectionformula property

.SelectionFormula = " WHere policyid = " & Session("policyid")

and the report prints correctly, then I select a different customer, the Session variable gets reset, (I'm sure) but the report outputs the report from the first PolicyID.

I've tried many times, selecting customers in many different orders, but the report always prints with the first policyid

Is there something I need to reset in the report to get it to accept the new .SelectionFormula ?
Who is Participating?
mlmccConnect With a Mentor Commented:
I don't know what the settings are, I know from what I have read on this site that it is an issue.

You might ask in the IIS and Web Browser froums

I assume if you use different policy id on the first run you get the correct data.

Crystal has a bad habit of caching the data.  Make sure IE and IIS are clearing the cache between runs.

jbh_blueAuthor Commented:
Yes, it is correct on the first time and the session vars which have the key are clear and reset correctly before the next try.

I tried


but got the same results

jbh_blueAuthor Commented:
thanks, because of licensing issues that I just found out about, I'm moving my reporting back into vs2008 using rdlc reports
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.