Hi, I have a problem with data not appearing on a report even though it is one of the tables
In simple terms we have Sales (all transactions), Products (all details relating to an item), and On Order (all outstanding orders)
An item that is On Order has had no sales yet so is not in Sales table, although it does have details in Products
I am only seeing records where there is something in Sales, regardless of the type of join used
I have tried every combination of joins between these tables - what would you suggest?
I have been using Crystal for about 6 years, currently on version XI and have always managed to solve this type of problem up to now but I am stumped
Thanks
Rocketgirl