<div>
I found it before I read your suggestion, but it was in the code run prior to calling the report. &nbsp;Jeez, can't believe how long I've been looking in the wrong place.<br />
<br />
Thanks for responding
</div>


I found it before I read your suggestion, but it was in the code run prior to calling the report.  Jeez, can't believe how long I've been looking in the wrong place.

Thanks for responding

<div>
Glad I could help<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
I am using VB6, the OCX, and CR6, with Access databases. &nbsp;<br />
<br />
I have a report which has two, linked subreports. &nbsp;Both subreports work fine running out of the OCX if I only select one record and it runs fine in the CR Developer against the entire Access database.<br />
<br />
But in either case if I use a conditional selection formula such as Mid({table.lastname},1,1) = &quot;B&quot;, then one of the subreports will not fire or run.<br />
<br />
I've noticed that if one subreport has data, then the other subreport is not populated. &nbsp;However, if the first subreport has no detail, then the 2nd one runs and is properly populated.<br />
<br />
Do I need to pass the selection formula to the subreports somehow or is there some way to force the subreport to refresh?<br />
<br />
Thanks in advance. &nbsp;I've been struggling with this for months and only recently found this site.<br />
<br />

</div>
</div>


I am using VB6, the OCX, and CR6, with Access databases.  

I have a report which has two, linked subreports.  Both subreports work fine running out of the OCX if I only select one record and it runs fine in the CR Developer against the entire Access database.

But in either case if I use a conditional selection formula such as Mid({table.lastname},1,1) = "B", then one of the subreports will not fire or run.

I've noticed that if one subreport has data, then the other subreport is not populated.  However, if the first subreport has no detail, then the 2nd one runs and is properly populated.

Do I need to pass the selection formula to the subreports somehow or is there some way to force the subreport to refresh?

Thanks in advance.  I've been struggling with this for months and only recently found this site.



Subreport does not refresh if using conditional selection formula

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.