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 ?
.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 ?
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.SetCacheabi lity(HttpC acheabilit y.NoCache)
but got the same results
Thanks,
I tried
Response.Cache.SetCacheabi
but got the same results
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks, because of licensing issues that I just found out about, I'm moving my reporting back into vs2008 using rdlc reports
thanks,
thanks,
Crystal has a bad habit of caching the data. Make sure IE and IIS are clearing the cache between runs.
mlmcc