Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

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?
0
Gocsteve1
Asked:
Gocsteve1
1 Solution
 
Gocsteve1Author Commented:
Oh, didn't mention, I am linked to the Username ID from both tables.....
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Generally speaking, you need to use a left outer join from your Users table to your Opportunities table.  That being said, if you apply any filters to the right hand table then you'll cancel out the left join.  Does that sound like your scenario?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now