RoseDCsyst
Technical User
Hello;
Need a little assistance with a report I am attempting to complete. I have 3 files from which I am getting data and I have used the Select Distinct Records under the Database tab but this is not eliminating my duplicates.
The files I am using are Task file, InvAdj File and finally Location file. Each of these files have what we call the long SKU which is Sea (season), SYR (SeasonYear), Style, Style Suffix, Color and SZCD (Size code) and SZPO (Size Posn) in addition to that the have Whse, Co and Div.
On the report I want to show all the records from the Task file that match, based upon certain criteria, the other two files and the resulting data I am receiving is what is expected except for the fact that there are multiple occurrences of the same record.
Is there a way to eliminate the multiples? I am uncertain to where to begin to look for the solution.
Appreciate any help. Not sure what information would be needed to clarify my request.
Thank you
Rose
Need a little assistance with a report I am attempting to complete. I have 3 files from which I am getting data and I have used the Select Distinct Records under the Database tab but this is not eliminating my duplicates.
The files I am using are Task file, InvAdj File and finally Location file. Each of these files have what we call the long SKU which is Sea (season), SYR (SeasonYear), Style, Style Suffix, Color and SZCD (Size code) and SZPO (Size Posn) in addition to that the have Whse, Co and Div.
On the report I want to show all the records from the Task file that match, based upon certain criteria, the other two files and the resulting data I am receiving is what is expected except for the fact that there are multiple occurrences of the same record.
Is there a way to eliminate the multiples? I am uncertain to where to begin to look for the solution.
Appreciate any help. Not sure what information would be needed to clarify my request.
Thank you
Rose