I have an issue with a Crystal Report that is showing too many records based on the records selected!
I have 2 tables, my main STK_Stock table, keyed on STK_StockCode and my STK_Location table which contains multiple records per STK_StockCode linked to Loc_StockCode.
Within the STK_Location table there is a LOC_Physical column which I want to sum on STK_StockCode.
I have tried (or I think I have) all variations of Groups and joins but I am unable to acheive my goal of producing a single line per STK_StockCode that contains the sum of the LOC_Physical from the STK_Location table.
I hope that makes and sense and someone can help!