<div>
Thanks very much for a quick and clear response. &nbsp;It worked.
</div>


Thanks very much for a quick and clear response.  It worked.

<div>
<div class="content wysiwyg-content">
I am trying to create a report that selects all results for learners if only one of their results is for a particular class. &nbsp;So, I only want the results for learners on this class but I also want the results for all their other classes.<br />
<br />
I am trying to incorporate a subquery into my record selection criteria but it doesn't like the syntax for the IN function.<br />
<br />
{course.parkey} = 14 and<br />
{results.ressdate} &lt;&gt;&nbsp;DateTime (1900, 01, 01, 00, 00, 00)<br />
and {results.stukey} in (SELECT stukey FROM results WHERE csekey=12249;)<br />
<br />
I have tried moving the SQL statement to a SQL Expression field but it fails because it returns more than one result.<br />
<br />
I'm using Crystal Reports XI and the database is MIcrosoft SQL Server.<br />

</div>
</div>


I am trying to create a report that selects all results for learners if only one of their results is for a particular class.  So, I only want the results for learners on this class but I also want the results for all their other classes.

I am trying to incorporate a subquery into my record selection criteria but it doesn't like the syntax for the IN function.

{course.parkey} = 14 and
{results.ressdate} <> DateTime (1900, 01, 01, 00, 00, 00)
and {results.stukey} in (SELECT stukey FROM results WHERE csekey=12249;)

I have tried moving the SQL statement to a SQL Expression field but it fails because it returns more than one result.

I'm using Crystal Reports XI and the database is MIcrosoft SQL Server.


Using subqueries in Crystal Reports record selection

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.