Hi
Thanks for any help in advanced.
I have created a report in Crystal 2008 that shows the following information from a Warehouse SQL Table:
ItemCode ItemName WarehouseQTY CommitedQTY AvailableQTY
1 Test Items 100 50 50
2 Test Items 50 10 40
This report has been grouped on the ItemCode field and there are details for different Warehouse's that have been totalled and then the Details have been supressed.
I wish to add some price information to this report from a Sales SQL Table, I have added the Sales table with the database expert and used an equal join on the ItemCode field.
I have selected three months of Sales data and I will to add a field which averages the Price information. When I run this now in Crystal it adds a Details line for each of the Sales lines and adds the WarehouseQTY each time.
I end up with a report that shows the Avg. price but the WarehouseQty is wrong.
How do I fix this?
Cheers
Dave Ainsworth