Finding out what people haven't bought

[mrliam69]

I'm stuck on trying to sort this one.....

2 tables
RefTable = StockCode, StockCAT
DataTable = Account, StockCode, Date

What I am trying to find out is from RefTable with a filter of StockCAT = 10112 or 10115 what products are customers not buying within a certain date range grouped by account

How would I set this one up ?

 

[Madawc]

You can do a left outer from product to customer, which means you get products with no linked customers. You can even select for them.

There is a problem if you also want to do a selection on the customers - that usually causes a Left Outer to fail, to become the same as a normal link. If this applies,. then you'd have to select everything and use detail suppression or group selection to get rid of the stuff you don't want.

You should have given your Crystal version, 8.5 or 9 or whatever. But the method in this case is pretty constant between versions.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[mrliam69]

Sounds like what is happening as the Left Outer appears to break , I'll try the suppression bit.

 

[mrliam69]

Gave up and did it in a spreadsheet in the end