Link to home
Start Free TrialLog in
Avatar of Gocsteve1
Gocsteve1

asked on

Linking Crystal - Two Tables, wanting to extract Null Value

I have two tables, one that has a Username and Sales Goal as fields....the other is our CRM system Opportunity table.   I have tried every linking scenario, and can't get the Crystal to pull data from either table when the Opportunity table has no data pertaiining to the username from the second table.

I'm trying to do a simple report to show those users who have done no business, but I end up with reports that only show users with business.

Any ideas on what I can do to get a null value report for users with goals but no business?
Avatar of Gocsteve1
Gocsteve1

ASKER

Oh, didn't mention, I am linked to the Username ID from both tables.....
ASKER CERTIFIED SOLUTION
Avatar of Kurt Reinhardt
Kurt Reinhardt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial