Help with table joins

[Rob_Radley]

I can't find a similar question answered already. What I need to do is report that lists every item in the item master (file 1) and lists quantity on hand (2nd file)and quantity on open orders (file 3).
File 1 has all sku's.
File 2 has Sku's that have a quantity on hand (if there is 0 on hand, no record exists)
File 3 has Sku's that are currently on open orders (again, if there is 0 on order, no record exists)
I need the report to print all sku's in one collumn, quantity on hand in the next, and on order in the third even if the sku does not exist in file 2, 3, or both.
I am linking the three files by sku#, but unless there is quantity on hand or on order in file 2 and 3, the sku# does not print on the report at all. I need it to print with a zero or blank value.
How do I accomplish this?
Thanks in advance for your help.

 

[georgedwilkinson]

Use the report wizard and pick all the tables that have the data you want to report on. Then follow the prompts.

 

[Rob_Radley]

ok, let me clarify,

I originally wrote the report using the wizard and connected the three tables by SKU#. The issue that I am having is that unless the SKU# exists in all three files, no data is brought back to the report. I want to print all the items in the item master file (primary file), regardless of whether matching records exist in the inventory and order files (files 2 and 3).
Thanks

 

[Kempes]

when you say file 1,2,3. Are these treated as tables by crystal?

Basically, all you need to do is edit the link from file 1 to a left outer.

This ensures it keeps all values from file 1 and only the matching records from the joining table.

 

[Rob_Radley]

Thanks

Yes, files are tables. The left outer join on the link options was what I was missing. Thanks a lot.