Solved

Linking Crystal - Two Tables, wanting to extract Null Value

Posted on 2013-02-05
2
250 Views
Last Modified: 2013-02-05
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
Comment
Question by:Gocsteve1
2 Comments
 

Author Comment

by:Gocsteve1
ID: 38854952
Oh, didn't mention, I am linked to the Username ID from both tables.....
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 38855143
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

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question