Link to home
Start Free TrialLog in
Avatar of jbh_blue
jbh_blue

asked on

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 ?
Avatar of Mike McCracken
Mike McCracken

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.

mlmcc
Avatar of jbh_blue

ASKER

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

Response.Cache.SetCacheability(HttpCacheability.NoCache)

but got the same results

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks, because of licensing issues that I just found out about, I'm moving my reporting back into vs2008 using rdlc reports
thanks,