Link to home
Avatar of ABM Support
ABM Support

asked on

Only want to see single records

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!

Many thanks

Steve
Avatar of Mike McCracken
Mike McCracken

Are you trying to return a single record from the database or show 1 line in the report?

mlmcc
Avatar of ABM Support

ASKER

I'm trying to show a single line in the report per STK_StockCode

Steve
ASKER CERTIFIED SOLUTION
Avatar of ABM Support
ABM Support

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial