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:
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
SELECT COUNT(DISTINCT Job_No)
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?