Skip to Content
0
Former Member
Feb 26, 2009 at 11:28 AM

Crystal Report from two SQL Tables

24 Views

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