Pulling Data from a Companion File

[msanders67]

I have a Crystal Report set up in the following manner:

Orders File linked to a detail file, a customer master file, and a customer ship-to file. I am pulling data from all of these files in some cases, but there is not always a customer ship-to record on file for every customer, in which case, nothing is being returned at all. Only if there is a ship-to record on file do I get a record returned. What I need is the data returned from other files even if there is not a customer ship-to record on file and the ship-to information returned if there is a ship-to code on file.

Is there a way to pull in every record from the main file, matching detail from the other 2 files and if matching records exist in the ship-to file, pull that data in as well, otherwise, ignore this file?

SO.Open.Header
| | |------->SO.Open.Detail (100%match)
| |------>AR.Customer.Master (100%match)
|
|------>SO.Customer.Ship-to (conditional match)

Additional FACTS: Crystal Reports 8.5 running with MAS90


Thank you in advance,
Margo

 

[FVTrainer]

Is this MAS90 running on a SQL Server?

If so, you need to change the link on the Ship-to file to be a left outer join. In the Visual Linking Expert, right-click on the link between the SO.Open.Header and the SO.Customer.Ship-to, choose options, and select the Left Outer SQL join type.

 

[msanders67]

It is not running on an SQL server. I rearranged the files and re-linked everything and viola' it is now working the way I need it to. Thank you for the tip however - I'm sure it will be useful in another application.

Thank you,
Margo