Greetings! I was trying to make a subject line more descriptive but I couldn't really summarize what I want to do in a single line. Anyway, we have an inventory database with multiple tables but i'm concentrating on two specific ones. One table is a list of Workstations, the other is a list of items that are within those workstations. For example (very simplified):
Table Workstation
Fields:WSNUM, USERNAME, OS
-----------------------
1, User#1, Windows 7
2, User#2, Windows XP
3, User#3, Windows XP
4, User#4, Windows 7
-----------------------
Table Item
Fields: NAME, TYPE, WSNUM
-----------------------
Dell Optiplex, Computer, 1
MS Windows 7, License, 1
Dell Optiplex, Computer, 2
MS Windows XP, License 2
Dell Latitude, Computer, 3
MS Windows XP, License, 3
Dell Precision, Computer, 4
MS Windows 7, License, 4
-----------------------
I'm trying to figure out how to make a report which will only show Workstations which DON'T have a particular item, for this example, workstations which don't have "MS Windows 7" as an Item. We are using Crystal XI and I can do is make a report which lists all items that don't match "MS Windows 7", but it shows all of the other items, even the ones on the same workstation. I just want to list the Workstations which don't have that one paritcular item in it. I've linked the two tables together using WSNUM as a common field.
Any thoughts? Thanks!