crystal reports selection criteria

Posted on 2008-11-11
Last Modified: 2012-05-05
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 ?
Question by:jbh_blue
    LVL 100

    Expert Comment

    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.


    Author Comment

    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

    LVL 100

    Accepted Solution

    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


    Author Closing Comment

    thanks, because of licensing issues that I just found out about, I'm moving my reporting back into vs2008 using rdlc reports

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now