I'm trying to build a report that tracks items sold to certain locations.

The items would be stored in a hold file...say 10 items, and then would be joined to another file which is grouped by location then item then a total (dollar amount).

What I need the report to show is all 10 items on the final report regardless of whether or not the item has a dollar amount attached. The problem I'm having is that the file that contains the sell infomration would not have a key for that item to join to because it does not have a previous sale. So the final report only shows the items with sales information.

Is there a way to do this?

I already tried using the hold file (with items) as the main table and joining to the sales info file but every field outside of the item number comes up as missing data.

Any help would be great, thanks.

Have you tried using Match instead of a Join?