troubleshooting Question

Crystal reports getting results from two tables where the data does not match

Avatar of Jasmin01
Jasmin01Flag for South Africa asked on
Crystal Reports
7 Comments1 Solution283 ViewsLast Modified:

I am trying to create a report that gives me the result of 2 tables.
 The two tables look like this:

Trips                              DailySummary                               Vehicles
Vehicle_ID                     Vehicle_name                               Vehicle_Id
Date                               Date                                             Vehicle_name
Trip                                DistanceTravelled

Now, I need to join the Trips table to the DailySummary table.  Then I need to check for only the records that belong to the DailySummary table, but do not exist in the Trips table.

Any idea on how to do this?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros