<div>
If you are trying to do it in the SQL try<br />
<br />
SELECT DISTINCT Job_No, Count(Job_No) as JobCount FROM MyView<br />
<br />
mlmcc
</div>


If you are trying to do it in the SQL try

SELECT DISTINCT Job_No, Count(Job_No) as JobCount FROM MyView

mlmcc

<div>
DistinctCount was exactly what I was looking for.<br />
<br />
Thanks.
</div>


DistinctCount was exactly what I was looking for.

Thanks.

<div>
<div class="content wysiwyg-content">
I'm using Crystal XI<br />
<br />
I have a report that lists jobs per cost center. &nbsp;Some jobs can show up on different cost centers. &nbsp;If I count records (how I'm currently doing it), I get more jobs than are actually on the report.<br />
<br />
My current query is something like:
<pre><code id="code-10-27028690-1">SELECT * 
FROM MyView</code></pre>
 which returns 150 records. &nbsp;This is not the number of jobs, since a job might appear in two or more rows with differing cost centers.<br />
What I need is something like 
<pre><code id="code-10-27028690-2">SELECT COUNT(DISTINCT Job_No)
FROM MyView</code></pre>
 which will return 85, the actual number of jobs.<br />
<br />
These, of course, would be filtered through Crystal's Record Selection Formulae.<br />
<br />
Is there a way to count just the unique records based on a single field?
</div>
</div>


I'm using Crystal XI

I have a report that lists jobs per cost center.  Some jobs can show up on different cost centers.  If I count records (how I'm currently doing it), I get more jobs than are actually on the report.

My current query is something like:(CODE) which returns 150 records.  This is not the number of jobs, since a job might appear in two or more rows with differing cost centers.
What I need is something like (CODE) which will return 85, the actual number of jobs.

These, of course, would be filtered through Crystal's Record Selection Formulae.

Is there a way to count just the unique records based on a single field?

Counting Unique Records

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.