Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal 2013, Matching records from 2 tables not linking

Status
Not open for further replies.

staciann

IS-IT--Management
Nov 1, 2006
72
US
Hi. I am using Crystal 2013. I am linking 2 tables from an MS 2013 Access DB. They are linked by the below fields in a 1:M relationship.

Table 1:
Issue ID (string)

Table 2:
Ticket ID (string)

I've linked these with a Left Outer Join and checked the data to make sure it was matching up exactly in the tables (making sure there were no trailing spaces, etc.), but I am still getting no data to show up. If I put one of the ID fields from either table in the report, all my records will show, but as soon as I add a field from the other table, it acts like there are no matching records from the other table and shows no records.

Do I have the join wrong? Any other ideas what could be causing the problem?

Thanks for your help!

Staci

Currently using Windows 7, Microsoft Office 2013, Crystal Reports 2013, Visual Studio 2010 & 2008, SharePoint 2013 (on prem), MS Dynamics CRM 2013 (online), MS Dynamics SL Version 7.0, Adobe CS5
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top