<div>
Related question<br />
<br />
<a href="https://www.experts-exchange.com/questions/23894364/crystal-reports-selection-criteria.html" rel="ugc">https://www.experts-exchange.com/questions/23894364/crystal-reports-selection-criteria.html</a><br />
<br />
mlmcc
</div>


Related question

https://www.experts-exchange.com/questions/23894364/crystal-reports-selection-criteria.html [https://www.experts-exchange.com/questions/23894364/crystal-reports-selection-criteria.html]

mlmcc

<div>
unfortunately they are both my questions.<br />
<br />
thanks
</div>


unfortunately they are both my questions.

thanks

<div>
I've got the same issue.... &nbsp;did you work out how to disable the caching?
</div>


I've got the same issue....  did you work out how to disable the caching?

<div>
<div class="content wysiwyg-content">
the first report that I set the .selectionformula property<br />
<br />
.SelectionFormula = &quot;&nbsp;WHere policyid = &quot;&nbsp;&amp; Session(&quot;policyid&quot;)<br />
<br />
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.<br />
<br />
I've tried many times, selecting customers in many different orders, but the report always prints with the first policyid<br />
<br />
Is there something I need to reset in the report to get it to accept the new .SelectionFormula ?<br />
<br />
Another export suggest that I clear cache, which I did using Response.Cache.SetCacheabi<wbr />lity(HttpC<wbr />acheabilit<wbr />y.NoCache)<wbr />, but that didn't work either.<br />
<br />
Another expert suggested that I re-post this in the IIS or Web Browser forums.<br />
<br />
<br />
<br />
<br />
<br />

</div>
</div>


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 ?

Another export suggest that I clear cache, which I did using Response.Cache.SetCacheability(HttpCacheability.NoCache), but that didn't work either.

Another expert suggested that I re-post this in the IIS or Web Browser forums.







Problem clearing cache when running crystal report from asp.net thru IIS 5.1

Web browsers are applications used primarily to display documents, files and media from the Internet, identified by a Uniform Resource Identifier (URI) that can be a page, image, video or other file. Some browsers require the use of add-ons or extensions to safely render the information they receive; others have systems built into them to perform the same functions.

Web Browsers

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.

Microsoft IIS Web Server

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.