Sage 100

Customer has a daily inventory report with tons of info (white space is a waste). Now If he adds a customer it will show what the customer last paid for an item. If it is blank the customer never bought that item. I tried a left outer join and I still only got equal information. If the customer didn't buy it, it was not on the report at all. So I have a subreport. Problem is it will take 4 hours to complete and also I don't know how to add the Customer name to the main report without using shared variable as this will increase the time to run. Instead of a sub I would prefer just linking 2 tables; customer info with Inventory info. The circled item on the attachment is the sub. Any ideas?

If you are using the select expert to filter on both tables, your outer join isn't going to work.

A subreport is probably still the better option. How are you linking to it? We might be able to make it more efficient so it doesn't take that much longer.

As Robert Wood said if the you are filtering on both tables it will ignore the join. But you can move the selection on the secondary table to the suppression formula in the details section.