Excluding records based on values in another table

[MAM]

I have two tables,

ADMINISTRATOR
UserID
Field1
Field2
.
.
.
AUDIT_TABLE
UserID
WhatIDid
AnotherField
.
.
.

I would like to create a report of the Audit_Table excluding the UserID's that exist in the Administrator table. The Administrator table changes frequently (about once a week or so), so I'd like to dynamically determine the UserID's from the Administrator table. Does anyone know how to do this? I'm connecting to my data via ODBC.

Thanks in advance,
MAM

 

[sureshraja]

hi mam

use query as follows.

select * from audit_table where userid not in
(select userid from administrator )

hope it works

 

[kenhamady]

That will work within SQL.

If you have to work within CR the approach is to link from User to Admin with a left outer join. Then use a selection formula like:

IsNull ( {Admin.UserID} ) Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[dgillz]

for non sql writers, th eresord selection formula is crystal would read isnull({ADMINSTRATOR.UserId})