Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Need Help with Report Post Reply Post New Topic
Author Message
jdobiash
Newbie
Newbie


Joined: 28 Oct 2011
Online Status: Offline
Posts: 1
Quote jdobiash Replybullet Topic: Need Help with Report
    Posted: 28 Oct 2011 at 2:32pm
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!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.