04-07-2016 7:25 AM
Hi Experts,
I am facing the scenario how to remove duplicate values from Query report.
When i am typing the code in report it is giving the Error. My question is the is it wrong coding ?? and if it is then what should be the correct one.
Regards,
Qamber Abbas
04-07-2016 7:30 AM
hi,
Dtab u declared as a structure.
try the following
data: dtab type table of quals-prueflos.
04-07-2016 7:30 AM
hi,
Dtab u declared as a structure.
try the following
data: dtab type table of quals-prueflos.
04-07-2016 7:40 AM
hi noufal,
system takes the code but still in report it odes not sort and delete the duplicate value.
You can go though screen shot.
regards,
Qamber Abbas
04-07-2016 7:44 AM
DATA: dtab type table of qals.
*populate dtab first
delete adjacent duplicates from dtab comparing prueflos.
04-07-2016 7:50 AM
It is now showing the new error, Please Type complete correct coding for my help.
04-07-2016 7:54 AM
04-07-2016 7:58 AM
04-07-2016 8:11 AM
data dtab type TABLE OF qals.
SELECT * FROM qals into TABLE dtab.
DELETE ADJACENT DUPLICATES FROM dtab COMPARING prueflos.
04-07-2016 8:48 AM