Want Partial Records / Not Sure How to Get Them

[brendag]

I need to know how many users at my company have IE 5.50 and DON'T have IE 6.0 (some people have every version showing up and I only want to know if they don't have 6.0). Ok, I can use the Select Expert to find out if they have 5.50 but what do I do to find out if they have 6.0 as well, without pulling in all the 6.0 users (thousands!)? I've tried stuff that seemed obvious but I'm getting confused. Do I use a formula? Can someone tell me what I'm missing?

Thanks in advance!

 

[IdoMillet]

The most elegant solution is to use a Query / View / or Command (Crystal 9) as the data source for your report.

use something like:
----------------------------------------------------
SELECT... FROM... WHERE some_column = "IE5.5" AND
emp_id NOT IN (SELECT emp_id FROM ... WHERE some_column = "IE6.0&quot
----------------------------------------------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com