Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Reports and Joins?
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Crystal Reports and Joins?
Miscellaneous
Thread ID:
00637417
Message ID:
00637417
Views:
41
Not getting expected results from Crystal Visual Linking using a Join option.

Table 1 has 1,2,3,4,5 in an ID field.

Table 2 has 2,4 in an ID field.

I linked this one ID field and that's all.

Whether I do an Equal Join, a Left Join or a Right Join I always get 2,4 on my report. I would like to get 1,2,3,4,5 on my report and show 1,3,5 as having 0 records and 2,4 as having 1 record.

What am I missing or doing wrong? Seems simple enough to me?!?
Thanks for a clue. Clueless in Clearwater.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Next
Reply
Map
View

Click here to load this message in the networking platform